Access file opening in Read-Only mode

Hi,

I've an MS Access file which opens in Read-Mode only.
How can I change the mode as I need to enter data?

Thank you
Deepak
deepakeeAsked:
Who is Participating?
 
peter57rConnect With a Mentor Commented:
Hi deepakee,

Have you copied this file to your harddrive from a CD?
If so, it might be set as read-only.
Right-click the file name and choose properties.  Uncheck Read-Only if it is set.

Another possibility is that you do not have write permissions on the folder containing the file.


Pete
0
 
dduserCommented:
Just Right Click on the Database File and change the File for writing... Does it ask for the UserName/Password....

Regards,

dduser
0
 
pradapkumarConnect With a Mentor Commented:
Hi deepakee,
What is the access permissions for that file.
Just Open access first and click on file->Open
and locate the database file then click the down arrow immediately to the open Button at there you can see exclusive open.
You can try that.

Best of Luck,
N.Pradap Kumar
0
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
deepakeeAuthor Commented:
when I double click on the mdb file, it tells me

"The database  'TestA' is read-only"
You won't be able to save changes made to data or object definitions in this database"
0
 
dduserCommented:
Right Click on your file outside MS Access and go in Properties, you will see your file is read only.

Check out...

Regards,
dduser
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
In addition to the above...

(1)  If you are using a shortcut to open it, do a right-click:Properties on the shortcut, then eyeball Target textbox, and make sure /readonly is not there.
(2)  You as the user may not have read-write permissions on the folder that the Access app is located, which would result in it being opened as readonly.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.