Why is access database readonly

Unfortunately, although you can take steps to minimize users' ability to do things you don't want them to do, it's hard to be absolutely sure you've closed all of the doors tightly. Before you get in too deep, check to see if Access is in fact the tool you want to use, or if you might do better to use an application specifically designed to work on the Web. Choose where you want to search below Search Search the Community. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

I have the same question 8. Report abuse. Details required :. Cancel Submit. Scottgem MVP. Hi Will, I'm an independent advisor and will try to help. There are a few ways to do this. The question is how secure do you want it to be. It's the 21st century now. This should not be happening anymore. Stack Overflow for Teams — Collaborate and share knowledge with a private group.

Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Access Database opens as read only Ask Question. Asked 10 years, 6 months ago. Active 7 months ago. Viewed k times. I created an mdb database and saved it.

Now I want to modify it but it says it's ReadOnly so I cannot change anything. It's an access file opened with access How can I change this please? Improve this question. Satch Satch Add a comment.

Active Oldest Votes. So try this: Open Access, but no database Open the file in question, but explicitly open it in read-only mode the 'Open' button is actually a dropdown button. Use the button to open read-only Close the file but not Access Open the file again, but open normally. Not sure it that's a bug or a feature, but I've seen it frustrate many a user. Improve this answer.

Steve Mallory Steve Mallory 4, 1 1 gold badge 26 26 silver badges 31 31 bronze badges. Alex Alex 71 1 1 silver badge 2 2 bronze badges. Tchilumba Mera Tchilumba Mera 41 1 1 bronze badge.

The Access 10 has no problem in operating the application. The Win 8 laptop randomly opens the application read only. I have reviewed Trust settings and there is no difference between the different laptops and systems.

Is this a common problem? Is it associated with Win 8? Is it associated with Access form Office ? The application is crucial to the business and we are getting way behind because we don't have a reliable or useful system. Last year the same application ran satisfactorily on Win 7 and Access Did you get the error message like "You are trying to open a read-only database". If yes, this issue may be due to the permission of the Access database. We need the full control permission of the Access database.

To workaround this issue, follow these steps:. Office Office Exchange Server.