 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 1 / September 2004Read Only problem
I have created a pretty straight forward database for one of the departments where I work. It's based on a design I used sucessfully for my own department so all of the components are tried and tested. Everything was working swimingly until now. Whenever a user opens the databse, it will only open in read only format. Does anyone have any idea why this might be happening, also how do I reverse this? Thanks in anticipation! Gareth This may seem a little obvious but did you by chance build the database on one computer and then either copy it over to the network via a CD or some other method? Sometimes when you copy a DB over I have found the "Read-Only" attribute gets set on the file. Right mouse click over the file wherever it's located on your network, select "properties" and check to make sure both the Read-Only and Archive attributes have been cleared. Hope this helps. Mike > I have created a pretty straight forward database for one of the > departments where I work. It's based on a design I used sucessfully for [quoted text clipped - 5 lines] > Thanks in anticipation! > Gareth Mike, Thanks for the reply. Yes, I built it on my PC then transferred it over the network from my own files to theirs. I did check the properties and the Read-Only attribute was definitely un-checked, can't remember about the Archive one though, will double check that one on Monday. Regards Gareth > This may seem a little obvious but did you by chance build the database on > one computer and then either copy it over to the network via a CD or some [quoted text clipped - 16 lines] >>Thanks in anticipation! >>Gareth > I have created a pretty straight forward database for one of the > departments where I work. It's based on a design I used sucessfully for [quoted text clipped - 5 lines] > Thanks in anticipation! > Gareth Get to the database window. Select File/DatabaseProperties. You may have to remove the RO attribute in Explorer. Or you may have a command line option in the shortcut to open as RO. Many thanks Salad! I'll give that a go on Monday. Any idea why this might have happened in the first place? Our IT department won't support anything they didn't have a hand in, so anything that prevents it happening again would be a bonus. Regards Gareth >> I have created a pretty straight forward database for one of the >> departments where I work. It's based on a design I used sucessfully [quoted text clipped - 9 lines] > have to remove the RO attribute in Explorer. Or you may have a command > line option in the shortcut to open as RO. Is it possible that your database is now located in a directory where users don't have all permissions? To effectively run an Access database in a shared environment, users must have read, modify, create and delete permissions on that folder. HTH - Turtle > I have created a pretty straight forward database for one of the > departments where I work. It's based on a design I used sucessfully for [quoted text clipped - 5 lines] > Thanks in anticipation! > Gareth |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.