Mulitple users for a database

C

Chris

I need some help. I've created a database that has a form users fill out
that saves the data to a table. The application is such that everytime a
user finds a quality defect they open this form and fill out a rejection and
it autopopulates the main table as a new record. I have created a code for a
field in the form that gives each quality rejection form a unique number so I
can trace each unique problem. Here is the code:

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

This code gives the field, "QAR No" the next sequential number for each new
record that is opened or created. After I got this form to work and populate
my table correctly I made a copy of the database and created links to the
main tables. I then installed this "copy" to each users computer so they
could use it when they needed to fill out a rejection. The problem I'm
having is that the database will only allow one user at a time to access and
fill out this form. How do I fix this. I alread checked the security and it
has the "shared" box checked. All my tables are links to the main tables.
The only thing I can think of is that it must be this code. Any advice?
 
C

Chris

I tried this and neither option worked. Any other suggestions. The problem
is that when one user has the form open all other users are locked out from
opening that specific form until the first user closes out. What it is
actually doing is locking out the table that the user is writing to. I
thought that code you suggested would have worked, but no luck.
 

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

Top