Question Multiuser db via linked table - record locking issue (1 Viewer)

[kiwipeet]

I have created an MS access database, which sits on the LAN and contains a single table. (The back end table has primary key).

​

I have created a 2nd Access db, to act as a front end, which attaches via a linked table. Each user has their own local copy of the front end.

​

I just want to give 2-3 users access to update the table. That's it, no forms, code or queries; I just want each user to be able to open the table as if it's a plain access table.

​

My problem is if one user has it open, others can't update the table or insert records. All settings are default. The db opens in shared mode with row-level locking enabled.​

Whoever opens the linked table first has exclusive access. Others can't insert or update records.​

If 2 users open the back end db directly they both have insert/update privileges. Why doesn't it work the same way with a Linked table?

Is this a known limitation of linked tables? Any ideas?​