Already opened exclusively? 1

[Remeartificer]

I have a database placed centrally on a network so three people can have access to it. I have not set up any permissions or anything. The file is just there and we all go to the folder and open/use it when required.

I have a form made to display buttons that lead to reports and a data entry form.

We all have access to the reports but when we click on the data entry button we get the following message:

......................
The table "name" is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically.
......................

Can anyone shed any light on this message? Thanks.

 

[lupins46]

Sounds like one or more of your users has their default database open option set to Exclusive. (Tools>Options)

You are risking database corruption sharing the file in the way you are using it. For multi-user operation you should use the Database Splitter tool to split into front-end and back-end, Then put the front-end on each users pc with the back-end on the shared drive. You can use the Linked Tables Manager tool to re-link the front-end to the backend tables if necessary.
Yo will find all this covered in Help.

 

[Remeartificer]

Thank you for that reply. Useful to know and I will act on your advice.

I did notice that when I went into the form properties it was set to lock all records. When I select only edited records it resolves the error message.

?

 

[lupins46]

The Lock All Records setting would explain the problem. This setting means that as soon as someone opens the table for editing it is locked from other users. This setting is hardly ever required in my experience, but both of the other two would be in common use. You need to check any forms that you have created while 'All Records'was set. Each form has its own locking option and it initially gets that from the default setting.