Form Error (Query Update)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

learning_codes@hotmail.com - 20 Dec 2007 21:14 GMT

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

Reply to this Message

Jeff Boyce - 20 Dec 2007 22:16 GMT

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

> Hi,
>
[quoted text clipped - 10 lines]
> Please help.
> Thanks

Reply to this Message

learning_codes@hotmail.com - 21 Dec 2007 00:00 GMT

> We aren't there. We can't see how your database is set up.
>
[quoted text clipped - 26 lines]
>
> - 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 ?

Reply to this Message

Minton M - 21 Dec 2007 00:14 GMT

On Dec 20, 4:00 pm, "learning_co...@hotmail.com"
<learning_co...@hotmail.com> wrote:

> > We aren't there. We can't see how your database is set up.
>
[quoted text clipped - 31 lines]
>
> 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

Reply to this Message