TechTalk: Performance Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27

 

Best Seats in the House

That’s it. Your goal was to optimize the database so many people can use it. You split the database into two programs and linked them together.

 

The tables can be stored on a server that everyone can access from the network. The forms and reports can run on each workstation.

 

When you are ready to deploy this database, each user will need a copy of the FORMS database on their computer. The TABLES database should be placed on a server or shared drive that all of the users can access.

Two Databases Linked Together

 

 

  Microsoft Access 2007 Exam 77-605 Topic: 1. Structuring a Database

  1.4. Split databases: For multi-user applications