We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Not shown are bunches of other tables with a foreign key of Customers.id.
Customers-Main.mdb id name date 1 Bob 1/1/2005 2 Jack 6/1/2005 3 Fred 1/1/2007 4 Jerry 12/31/2010
All is well. BUT, I'd like to also be able to do a restore as well, meaning in the above example if I restore all rows beginning 1/1/2015, the id=1 and 2 rows move back to the Main.mdb, and because of the foreign key rows I need to specifically insert the values 1 and 2 into the AutoNumber ID field.
Customers-Main.mdb Customers-Archive.mdb id name date id name date 1 Bob 1/1/2005 2 Jack 6/1/2005 3 Fred 1/1/2007 4 Jerry 12/31/2010
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|MS Access / SQL Server - ODBC Problems||16||51|
|Access module into a teradata procedure or db2 procedure||18||75|
|MS Access - Autofill field with item description||6||48|
|Convert MS Access Excel Routine to Late Binding||6||20|
Join the community of 500,000 technology professionals and ask your questions.