Creating a Front End Database

 

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.

 

 

See also