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?