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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 420
  • Last Modified:

Access opening incorrectly as Read Only

My access database is opening as Read Only, but it shouldn't.
There is noone accessing the database and no reason to be readonly.
Is there a way I can prevent this from happening?
If there IS someone connected, is there a way to disconnect them?
THANKS!!!
0
Euro5
Asked:
Euro5
  • 2
  • 2
  • 2
  • +3
2 Solutions
 
DcpKingCommented:
Have you checked that you yourself don't have it open in another window somewhere (probably minimised) ?  Alternatively, did it crash or did you turn off the machine with Access still running? If so, close it, get rid of the lock file in the same folder as the Access file, and try opening it again.
0
 
dimmergeekCommented:
What version of Access?
Are you opening the database from a 'Trusted Location'?
You may need to manually set the location of the database to be trusted.
0
 
Euro5Author Commented:
My version is 2010.
What if I have users accessing the tables through excel?
I have some users who create tables in Excel and refresh the data periodically.
Is there a way to update (not open in READ ONLY) if they are using as a datasource?
Thanks!
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
Right click on the file in explorer and make sure the file is not marked as read only.  If it is, un-check the box.

Jim.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
"What if I have users accessing the tables through excel?"
Pretty sure that is a problem ...

mx
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
You might be able to tweak this code to see IF anyone else is in the db (accdb), or use as is if you are running MDB in A2010.

LDB Viewer Form
http://access.mvps.org/access/modules/mdl0055.htm
0
 
Oliver WastellMemberCommented:
Hi Euro5,
Have you recently moved the database file?  I've had a similar problem on multiple occasions after I move a database file.  The solution (if it is the same problem) is similar to that proposed by JDettman above, but not quite as obvious.  Right click on the file in explorer and select properties.  Next to Attributes, click on the 'Advanced' button.  If 'File is ready for archiving' is checked, uncheck it and click 'OK'.
Hopefully that'll resolve your problem.
Oliver
0
 
Euro5Author Commented:
Thanks so much - this was VERY helpful!!
0
 
Oliver WastellMemberCommented:
I'm happy that we were able to help.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
  • 2
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now