How link a table on a shared drive to a database for multiple users

[mkk]

Hello,



I have a database on a shared drive, for multiple people to access at once, that I linked an excel table to. I run queries from the linked table and on the database's main form, I pull feilds from the queries. The people accessing the database have Access 2007 and Access 2010.

The people with Access 2007 can access the database fine, but the people with Access 2010 receive an error when someone has previously opened the Main Form of the database. The error says "The Microsoft Access databse engine cannot open or write to the file [the table in the shared drive]. It is already opened exclusively by another user, or you need permission to view and write its data." meaning that only one person can access the table at a time. If the person with Access 2010 opens the main form of the database before anyone else, they can use it fine, but if someone else openes it first, it will come up with the error message.

Is there any way to get around this error? (This is why we linked the feilds in the main form to the query instead of the table)

Thanks!

[June7]

Everyone is opening the same copy of the frontend? Here's how I distribute db to multiple users http://forums.aspfree.com/microsoft-...ue-323364.html

[rpeare]

Check out this:

http://www.pcreview.co.uk/forums/set...-t2875444.html

Basically in order for multiple people to have access to your database you have to set the permission for each person to read/write that will be using the database for the ENTIRE FOLDER the database is in.