Record Locking Issues in Shared Database

[ladysnake38]

I have a database where multiple users may be signed on at a time. I'm being told that if more than one person is in the database they receive the following error message " <FileName> can't save design changes or save to a new database object because another user has the file open. To save you design changes or save to a new database object, you must have exclusive access to the file."

I have checked and the appropriate box is checked to allow sharing in the database. No record locking.

Any suggestions on how to fix this?

Thanks.

Cheryl

[Allan Murphy]

This message occurs when you try to make design changes to a database that is open by another user or other users as you do not have exclusive use of the database. For ordinary updating the data this message should not appear.

[ladysnake38]

Hi Allan:

Understand, but they're not doing design changes to the form. What they are doing is changing information in a form that is then linked to multiple queries and reporting. Would this type of linking be construed as a design change?

It is the only explanation I can come up with.

Thanks!
Cheryl

[LICKY]

I would suggests you go to Tools (on menu Bar) and select Options. Then click on the Advanced tab and set the "Default open mode" to shared and the "Default record locking" option to "Edited record". This pesamistic record locking should solve your problem.