Multi-user environment issues

[PaulA]

Hi, alll--

I have an A2K database on a shared drive for multiple users.

I have a form in continuous forms view. There is a checkbox on each record where, if checked, the record will be printed on a report. There are two update queries for selecting and deselecting the checkbox in all records. These are triggered by command buttons, and the deselect query is triggered upon opening and closing the form. This is done by docmd.openquery code.

If a user is in the database, any additional users will get an error message when the queries are triggered saying that "Operation must use updatable query" or something similar. This does not occur for the first user.

Can someone explain to me why this occurs and how to get around it?

Thanks.

Paul

 

[gemma-the-husky]

are you using any form of record locking?

 

[PaulA]

Thanks for your response.

Turns out that one user had a specific access configuration through Citrix where she didn't have the appropriate rights at one place. This was causing problems both for her after I installed some action queries to the database and also to other users when she was in the database. This was corrected.