multi user access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a table that has two forms. one form adds jobs whilst the other
searches the table and displays the job. the search function is required as
we are adding 300 new records daily.

when the person is in the form to add new records I am unable to search the
table. it says that the table is locked. is there any way of changing it so
the cell is locked rather than the whole table? i need to be able to search
while someone else is adding records.

any help is appreciated.
 
Assuming your record locking is set properly, you should be able to do this
without any issues. Check your record-locking in Tools/Options/Advanced.
 
The settings should be:
Default Open Mode = Shared
Default Record Locking = No Locks
Open databases using record-level locking = Checked
 
You must log in or register to reply here.

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
error 2489 1
Access 2007 Tabbed form with shared recordset 0
VBA - retrieve data on last create named range from previous inserted named range 0
Need help to Simplify a Complex Calculation on a Form 0
Add new records into source table on Form 8
Help with form load 5
Locate existing record-update it on the form 3

Back
Top