Asked • 03/13/19

How do I allow multiple people to open my Access database?

I have an incredibly simple Access database. It has one pass-through query and that's it (no tables). The query simply executes a stored procedure against a SQL Server database to display the results. There won't be any data saved in the Access database; it will only be used to display the results of stored procedures.I put the database on a network share. If I have the Access database open, non of my co-workers are able to open the database to view the data. They get the error: "Could not lock file".How can I allow multiple users to open the Access file and view the query results?

1 Expert Answer

By:

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.

OR

Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.