problems creating a muti-user database

[Chris]

I have taken the steps recommended by some to split my datbase into a front
end and back end in order to allow muti-user access. The back end only
contains the main table. The front end contains the queries, forms, reports,
macros, and links to the main tables. In the advanced tab under
Tools>Options I have made sure that "shared" is checked as the default. Each
front end has been saved as its own file for each user on their desktop. The
back end is saved on the network. I am still getting this message when other
users try to access the main form on the front end at the same time:

"The database engine could not lock table 'tblQARmaster' because it is
already in use by another person or process."

All the users need to access this main form on the front end simultaneously
to be able to write to the main tables. Is there something else I need to do
to make get this to work? What else could cause this message?

 

[Chris]

Thanks Chris. That worked, but now I have one additional problem. When a
person opens up the form and starts writing it automatically populates the
entry number of the record so people can search by this number and make edits
if necessary or view information about that specific entry. Here's the code
I'm using to in the Before Insert event:

Text5 = Nz(DMax("[QAR No]", "qry_QARNo_Value"), 0) + 1

This code goes and views the last entry number on the table and adds 1 to
autopopulate the field with the next sequential number for the record when a
user begins writing. Now that I made the changes you suggested to "no
locks", when multiple people open the form and begin writing it gives them
both the same entry number. What I need is that both users are given two
different numbers that are in sequential order based on who starting writing
first. Ideas?

Change the record locking from "all records" to either "no locks" or "edited
record" and set record level locking:

1 - Tools > Options > Advanced.
Default record locking = no locks (or edited record).
[x] Open databases using record level locking

2 - On the form, change record locks property to no locks or edited record.

Chris

I have taken the steps recommended by some to split my datbase into a front
end and back end in order to allow muti-user access. The back end only
contains the main table. The front end contains the queries, forms, reports,
macros, and links to the main tables. In the advanced tab under
Tools>Options I have made sure that "shared" is checked as the default. Each
front end has been saved as its own file for each user on their desktop. The
back end is saved on the network. I am still getting this message when other
users try to access the main form on the front end at the same time:

"The database engine could not lock table 'tblQARmaster' because it is
already in use by another person or process."

All the users need to access this main form on the front end simultaneously
to be able to write to the main tables. Is there something else I need to do
to make get this to work? What else could cause this message?