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
 
Back
Top