Linked tables but read only allowed with multiple users



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.

Ken Snell \(MVP\)

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


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question