Access 2010 Database Opens In Read-only Mode. How To Normalize It?

Asked By cindy schauman 10 points N/A Posted on - 11/16/2020

Access 2010 database opens in read-only mode. I am unable to do any work on it. Is there any way to open it in normal mode?

• Status: Open
• Question Views: 28
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Hardware
• Question Tags: Windows

Answered By Ronald C Tran 0 points N/A #345005

Access 2010 Database Opens In Read-only Mode. How To Normalize It?

Access 2010 database opens in read-only mode. This problem occurs if you have the database opened somewhere else.

Method 1

Close the database if it is open somewhere else or ask the person who uses it on some other device to close it. If the database is using files and the files are opened, it may throw the error.

Method 2

This method has done wonders for me.

a. Open Access.
b. Select the Database and click on the drop-down in the open option.
c. Select the read-only mode.
d. Close the database. Do not close Access.
e. Open the database normally.

Method 3

a. Open Database.
b. Go to Properties.
c. Open Security.
d. Take ownership of the database.

Method 4

If you are using a shared folder or someone has given the database access to you, then there can be a restriction on the database. Remove the restriction to continue using the database.

About Ronald C Tran

Questions
4

Answers
5

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/16/2020
• Question Category: Hardware