Microsoft Office Tutorials and References
In Depth Information
Editing with Multiple Users
7. Click OK to close the Select New Location Of dialog box.
You return to the Linked Table Manager dialog box .
8. Click the Close button in the Linked Table Manager dialog box.
Now Access knows the correct locations of your linked tables.
See Book II, Chapter 4 for information about creating a link in one database
to a table in another database.
Editing with Multiple Users
To set up Access so that more than one person can open your database at
the same time, you don’t have to do a thing other than store the database
file in a shared folder. Access has multiuser features built in! Just open the
database one time on your computer and again on a second computer. Poof!
Both computers are using the database!
Everything works fine if multiple people use front-end and back-end
databases, too. One back-end database lives in a shared folder, and multiple
people have copies of the front-end database running on their computers.
When several people open the front end at the same time, they all link to
tables in the back end. No problem!
Multiuser access works great as long as everyone looks at the data without
making any changes. Two people can look at the same table — even the
same record — at the same time. People can open forms and print reports.
Fixing exclusive access
Okay, you may have to do one thing: If the second person who tries to open
your database gets an error message saying that the database is already in
use, it means that the database is in exclusive mode and can be opened by
only one person at a time. (How very exclusive!) If this happens, the person
who has the database open must follow these steps:
1. Click the File tab of the Ribbon, and select Options in the list on the
left side of Backstage View.
2. Select Client Settings in the pane on the left.
3. Scroll down to the Advanced section, and set Default Open Mode to
Shared (see Figure 2-2).
Search JabSto ::

Custom Search