Dan Waters
df.waters at comcast.net
Tue Feb 5 10:03:14 CST 2013
Hi Guss, I've had this issue when someone who was logged in has disconnected in a way which leaves the server thinking that someone is still using it. If you have server Admin rights, go to the Administrative Tools | Computer Management. In the left task pane, open System Tools | Shared Folders. Open the Open Files folder to see if there is a line which shows the path to your file. You'll be able to see which user name is still connected. If you know that person is actually logged off (from their PC), then you can go to the Sessions folder, find that user, and right-click to disconnect that user from the server. Or, ask your IT folks to check on this. Hope this helps! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Guss Ginsburg Sent: Tuesday, February 05, 2013 9:29 AM To: accessd at databaseadvisors.com Subject: [AccessD] DB Suddenly becomes Read Only This is the second time this has happened to my back end db. The first time was about 6 months ago, and I resolved it by copying the tables into another new db, and relinked the tables in the FE to the new BE. Anyone know what may have caused this? The files are all in 2002-2003 format, and are running in Access 2010 environment. The last time this happened, they were running in a 2007 environment. The system properties and security settings seem to be the same as other DB's which work fine. I cannot rename the R/O file, or delete it. The BE is shared among a small handful of users (never more than 3 or 4). Sincerely yours, Guss Ginsburg -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com