Form Error (Query Update)

[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

 

[Jeff Boyce]

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

 

[learning_codes]

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 -

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

Rigtht ?

 

[Minton M]

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

Rigtht ?

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