I'm using MS Access 2007.
I've two Access databases: dbTables, dbApplication.
dbTables consist of data tables (dbTables is Password Protected e.g. abc123)
with tables with primary key ID in each table:
Customers, Products, Orders, OrderDetails
dbApplication consist of Forms & Reports.
with...