"Default open mode" with Access project (*.adp)

[balor]

If you create an Access project and use it with MSSQL-server you can’t specify "Default open mode"(Advanced tab on options). You can’t specify it by code either. It is always "Exclusive". I want the users to use the same .adp or .ade file on the server so I don’t need to copy it to the local computers. This works fine but if more then one user are opening the file they get a warning that the file is read only because the first user has open it in exclusive mode. I thought the problem should be solved when I created an .ade file from the .adp file but the warning is still there.

Any suggestions?

 

[Waynest]

I dont think you'll be able to do what you're suggesting. You'll probably need a batch file or similar which pushes out a new .adp to your users when you have made an update.