This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi - I am having a real problem with a database I have created on a shared network. I have checked that the client settings are set to Default open mode "shared" and I have split the database to a FE and BE and nothing works!!!
It is designed with data coming from a linked csv file (because the data is updated every day).
The users enter search criteria into a form, then run a report from a button on the form which uses a macro to open the relevant report.
The report is run from a query where the criteria is set to be the value of the fields on the form.
It works fine if I am the only one using it but the minute someone else opens the database and tries to run a report they get the following errors:
"The Microsoft Access database engine cannot open or write to the file "", .It is already opened exclusively by another user, or you need permission to view and write its data."
If you click OK users then get an error message saying:
Macro Single Step - Stop All Macros
Action name: OpenReport
Error Number: 2950
If users decide to stop all macros nothing works at all!!
I am quite new to access but have completely lost heart as this has taken me hours and now seems even less useful than excel. Any help would be greatly appreciated.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Different security levels for folders is not fancy. Especially for a school. But the point is if a lock file is not being created for the BE, that's probably the source of the problem.
Hi thank you... I will double check that tomorrow, but I work in a school and I dont think we have anything as fancy as different levels of rights to different folders. Is there anything else at all it could be?
Many thanks!
If, when you have the table opened in the front end and there is no lock file created in the BE folder, then the problem is the permissions assigned to BE folder. Every user needs Read/Write/Modify rights to that folder.
No - I only see it in the FE folder?
Hi- I have checked and our network is listed as a trusted location so that seems to match up. The description says all DFS roots? I don't know how to make the BE create a lock file - what do I need to do?
Thank you!