Technical details for the Board library
Experienced Access Users only
Using Windows Explorer copy the Live board library database to another directory. The files to copy are:-
MMATV11.MDB
or
IMATV11.MDB
In Access create a New empty Access Database
In the new Database move to the 'Tables' option and create 3 new tables by linking to the Board library tables (in the copy database). The table names are:-
Materials
Boards
Transactions
Create any queries or reports in this Front End database.
Notes
- If any changes are made to the data in the Copy database it is necessary to co-ordinate these changes with the Live database. Make sure the appropriate procedures are in place for this.
- Do any editing via the Front End database. This edits the data in the copy database. To make edits directly in the copy database or via the Front End database.