Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / August 2005

Tip: Looking for answers? Try searching our database.

coping records

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
cedtech2 - 15 Aug 2005 22:43 GMT
how can i copy selected records to a new database while maintaining the
numbering that was originally assigned by auto numbering and relationships. I
am using access 2000
John Vinson - 16 Aug 2005 00:37 GMT
>how can i copy selected records to a new database while maintaining the
>numbering that was originally assigned by auto numbering and relationships. I
>am using access 2000

Use File... Get External Data... Link to link to the existing tables;
create your new tables, empty, perhaps by using File... Get External
Data... Import and selecting the option to import the design only.

Then run Append queries to selectively append the desired records. If
you Append to an autonumber field, the value will be copied
faithfully, and will not autoincrement; the next autonumber when you
add a new record will be one more than the largest imported number
(though its exact value should not be of importance other than that it
is unique).

                 John W. Vinson[MVP]    
KARL DEWEY - 16 Aug 2005 02:07 GMT
If you are talking about using an autonumber in the new database just create
your table structure including autonumber field.  Paste Append the record
including the number field.
This will work so long as your do not have a duplicate number.  
But where do you plan to go from there?  Continue to copy and append?  
Are will you start add new records standalone in the new database?

> how can i copy selected records to a new database while maintaining the
> numbering that was originally assigned by auto numbering and relationships. I
> am using access 2000
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.