Using Linked Tables in a Desktop Database

Your first foray into the world of shared applications will most likely involve copying your completed database to a file server and instructing users to open the database from the server. That’s basically not a good idea because Access client doesn’t run on the server—it runs on each user’s desktop. If you have several users sharing a database file, the copy of Access running on each user computer has to load all your “code” definitions—the queries, forms, reports, macros, and modules—over the network. If one user applies a sort or filter to a form and then closes it, Access will try to save the changed definition in the copy on the server, and it might run into locking or corruption problems if another ...

Get Microsoft® Access® 2010 Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.