Linked tables but read only allowed with multiple users

  • Thread starter Thread starter TDC
  • Start date Start date
T

TDC

I have a manually split db. The back end is linked to two additional tables
from another database. I have 4 locations each with a seperate front end,
but backend is on a server for all to use. Works great until 2 locations try
to add records at the same time. The field using the equipment tables for
look up gives a read only error.

I've set the table options to shared, but am at a loss. Please help.
 
Check the form that is used for adding the records in the front end file.
Open the form in Design view, click on Properties icon on toolbar, and click
on Data tab. Be sure that the Record Locks property is set to Edited Record.

--

Ken Snell
<MS ACCESS MVP>

..
 
Back
Top