Database won't allow multiple users

Question

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.

Answer 1

Do you see the lock file in the BE folder?

Answer 2

A lock file needs to be created for BOTH the FE and BE. The lock file is created in the same folder where the file is. So you need to check the BE folder.

As far as Trusted Locations, you can check this by selecting File>Options and opening the Trust Center.  I'm not sure I would trust your IT department (unless they are very familiar with Access) to know what Trusted Locations mean in Access vernacular.

Um that's still code. But if all the macro does is use the Open Report Action and nothing else that shouldn't be the problem. So next we would need to look at the Recordsource of the report.

Answer 3

I didn't use a code - I am a real beginner, so I just inserted a button and used the macro builder - so I just used the OpenReport option. Do you think that's the problem?

Answer 4

Hi - when I open it I see the lock file in the same location as the FE - I have clearly done something wrong!

I wasn't sure about the trusted location but I have been told by my IT dept that it is.

Answer 5

Humor me and tell me if you see the lock file with the BE file after someone has opened your application. Also, have you setup the FE folder as a trusted location?