Why is code opening a Project in Read Only

[johnmidcap]

Hello.

I'm a long term Access 2000 & 2003 programmer and just recently our company moved to Access 2007.

A large mde (split fe and be) that we upsized to SQL, allows a user to login and then opens the Project again using the code below. The empid = 1 which runs a piece of code. The problem is that the Project is being opened as Read Only. Can anyone explain why?

Thanks,

John

stAppName = "MSAccess.exe """ & CurrentProject.Path & "\" & CurrentProject.name & """ /cmd " & empid

 

[ajrimmer]

You say "opens the project again" - so are you opening up two instances of the front end at the same time?

If a front end is already open (by the current or other user) then subsequent users will get a read only warning (which relates to changes to the front end, not the data on the server).

I've always gone for a distributed front end which avoids this "issue"