Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
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
|Access 2016 - Labels prompt to print||4||30|
|Does anyone know of an easy way to Uninstall Office 2010 but not Access 2010?||4||21|
|SQL Group on First occurrence||9||24|
|Trying to force an answer in a combobox||7||11|