Software

Ask something
Discussion Locked

Access 2000 and table linking

0 helpful
5 replies

by Member 36022913

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

What do I need to do to get Access to share linked tables?

When one application opens a linked table using Access2000 another user is locked out from the table. However if a user opens the table using Access 97 more than one user with either Access 2000 or Access 97 can open the table.

I am using Access 2000 to link to some Access 97 tables. This is more or less a front/end back/end arrangement where each user has the modules, forms, etc residing locally on their hard drive but link to the shared data tables.

5 replies

by richtee

There are multiple aspects to take into consideration in handling your situation. Different types of locking can be done ? eg: at the record set level, the table level, etc.

There is some help and information about this in the Help Index file searching for ?lock?. Following is one such result that may help resolve your situation.

Specify the default record-locking strategy used in a multiuser environment in an Access database
1. On the Tools menu, click Options.
2. Click the Advanced tab.
3. In the Default Record Locking box, click the option you want.

Good Luck, Rich

by Member 36022913

I had to double check, and I wanted to make sure I had been down this path. The problem is really at the table level. Frequently, when one user has the database open the entire table is locked out from viewing, editing, or any access.

This discussion is closed to new replies.