General discussion

Locked

Access 2000 and table linking

By david@haydenpub ·
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.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 2000 and table linking

by david@haydenpub In reply to Access 2000 and table lin ...

Point value changed by question poster.

Collapse -

Access 2000 and table linking

by RichTee In reply to Access 2000 and table lin ...

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

Collapse -

Access 2000 and table linking

by david@haydenpub In reply to Access 2000 and table lin ...

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.

Collapse -

Access 2000 and table linking

by david@haydenpub In reply to Access 2000 and table lin ...

Point value changed by question poster.

Collapse -

Access 2000 and table linking

by david@haydenpub In reply to Access 2000 and table lin ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums