Form Error (Query Update)

  • Thread starter Thread starter learning_codes
  • Start date Start date
L

learning_codes

Hi,

I have about 12 people to work on the database and each has own userID
and password. Their UserID and Password input and the form link to
the query that has the filter on "UserID and Password" for their
input.

The message said "Can't Update; Query Locked".

Is there I do something wrong? I thought the form is the shared for
everyone to input based by UserID and Password.

Please help.
Thanks
 
We aren't there. We can't see how your database is set up.

For instance, do you have a split database, with a single "back-end" file on
your network and a copy of the "front-end" on each user's PC?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
We aren't there. We can't see how your database is set up.

For instance, do you have a split database, with a single "back-end" file on
your network and a copy of the "front-end" on each user's PC?

Regards

Jeff Boyce
Microsoft Office/Access MVP










- Show quoted text -
Click to expand...

If I split the database, will it solve the problems and won't get any
error message "Can't update; Query locked' ?

Rigtht ?
 
If I split the database, will it solve the problems and won't get any
error message "Can't update; Query locked' ?

Rigtht ?
Click to expand...

Jeff's response mirrors my own. You need to provide much greater
detail such as:

1. Is everyone logging into the same mdb file?
2. Are they all using same form?
3. What the query/table structure?

I you have one table and one query and one file, I can see why you're
getting locking errors because it just doesn't work that way. Send us
more details and we can help.

-- James
 
Back
Top