Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Access file opening in Read-Only mode

Posted on 2006-11-27
6
Medium Priority
?
1,248 Views
Last Modified: 2012-06-27
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
0
Comment
Question by:deepakee
6 Comments
 
LVL 9

Expert Comment

by:dduser
ID: 18018468
Just Right Click on the Database File and change the File for writing... Does it ask for the UserName/Password....

Regards,

dduser
0
 
LVL 9

Assisted Solution

by:pradapkumar
pradapkumar earned 300 total points
ID: 18018471
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
 

Author Comment

by:deepakee
ID: 18018498
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 77

Accepted Solution

by:
peter57r earned 1200 total points
ID: 18018506
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
 
LVL 9

Expert Comment

by:dduser
ID: 18018507
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
 
LVL 66

Expert Comment

by:Jim Horn
ID: 18019127
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question