munkeyroot
Registered User.
- Local time
- Today, 04:06
- Joined
- Jan 13, 2011
- Messages
- 76
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
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