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

They all have their own copy.

Answer 2

Hi...Yes all users have those permissions for the BE and all have their own copy of the FE. That's why I'm so confused.

Answer 3

Can you show us the code where they are trying to run the report? A third possibility comes to mind that you are trying to write to that csv file.

Answer 4

"I have split the database"

Does each user have their own local copy of the FE, or are they sharing a common copy?  They each need their very own copy.

Duane's comment regarding permissions is also critical, so be sure to validate that.

Answer 5

Do all users have create, delete, read, and write permissions to the folder containing the BE? They must.