Database keeps opening as READ-ONLY??

[golfnut019]

Everytime I open up my Access database, it says "This database has been opened read-only. You can only change data in linked tables. To make design changes, save a copy of the database."

This DB is saved on my desktop. ( I'm getting familiarized with Access 07 so I'm running some test DB's. )

Anybody know how I can get rid of this?



Thanks in advance!

 

[SydneyGeek]

That will do it. I avoid linking to Excel because either application can lock the other up, and you can't edit the Excel data from Access. In addition, the performance is much slower than for a native table.

Denis

 

[aladin347]

Thanks this tip did the trick

 

[haus14580]

Just a quick note in case it helps anyone else... I ran into this problem as well and the cause was quite simple in the end - I had an Excel document open that had a data connection to the database in question. Closing the spreadsheet allowed me to open the DB as normal.

This was my issue, and here is the permanent fix;

In Excel, look at the properties of the connection to your Access database. You should see one of the two lines in the connection string.

"Mode=Share Deny Write"
or
"Mode=Share Deny Read|Share Deny Write"

Change it to;

"Mode=Share Deny None"

Now you can open your MSA db and make changes to it while your XLS is open.

 

[Nine Zero]

Now what happens if SOME users are able to use the XLS with "Mode = Deny Write" and the others cannot. Would it be an issue with rights to a certain version of the program, or updates? Any ideas?

 

[xenou]

If that's in regards to the advice in the previous post, that's a property within the connection information inside the Excel file, telling it how to connect to Access. So should be the same for all users by definition.