Importing specific records tables

[munkeyroot]

Hi Everyone
I know this is not best practice for an access DB, however until i can find a better solution i'm a bit stuck

So my main DB has auto gen PK - i also have other related sub tables with PK and FK to my Main db.

i also have FE and BE

i have had to take a copy of my DB away from the server to work on - i set myself up with a range of main DB PK numbers from 1154 to 2000 with "do not use" on their descriptions so anyone on the server DB will know not to use them.

Now i have done my work to the main DB and all its sub Tables, how do i now import the Main db and sub Tables back to the Server DB.

i hope this makes sense and i hope you can help as my scripting is not brill

cheers munkey

 

[Ranman256]

you would run update queries.
update the master from your copy,
then update or append the subtables from your copy.