Cannot update main table if linked table is open

G

Guest

I have a split database with a form (in the front-end db) used for searching
a table that is linked to the main table in the back-end db. If the form is
open when I attempt to update the main table I get the following error
message: "You tried to lock table (tablename) while opening it but the table
cannot be locked because it is currently in use".

The form Record Locks property is set to "No Locks" and the Recordset type
is "Snapshot". The default record locking for both dbs is set to No Locks.

How can I set this up to be able to update records on the main table if the
form is open?
 

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

Similar Threads

Separate Form 0
Records have become locked 9
Multiple users on linked excel table 1
Find name in subform using cbox and go to that record # in main fo 2
Opening Lookup Table 5
error 2489 1
different forms linked to one table 1
Order By ineffective when displaying main form/table 1

Top