 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Multiuser / Networking / April 2004Double Post Compact Problem
I have a access97 mdb that will not allow me to compact. It tells me > that two users are tying to update the same data. I have gotten > everyone out and searched for lock files and have found none. > > One user can get in the program very quickly (I would imagine this is > one of the users that the program thinks is updating a record) > another user can get in but it takes a minute or two for the program > to load up. Another user gets a file in use error when they try to > open the program. I have opened the Access97 mdb in exclusive mode but when I try to compact I still get the error that 2 users are trying to update the same data. I have searched every computer (3) on the network for ldb files and have found none. Any way to find out what record the system thinks is being edited by 2 different people at the same time? TIA I would make a copy of the file, compact and repair it, then replace the defective file with your copy. Rick I have a access97 mdb that will not allow me to compact. It tells me > that two users are tying to update the same data. I have gotten > everyone out and searched for lock files and have found none. [quoted text clipped - 4 lines] > to load up. Another user gets a file in use error when they try to > open the program. I have opened the Access97 mdb in exclusive mode but when I try to compact I still get the error that 2 users are trying to update the same data. I have searched every computer (3) on the network for ldb files and have found none. Any way to find out what record the system thinks is being edited by 2 different people at the same time? TIA > I have a access97 mdb that will not allow me to compact. It tells me > > that two users are tying to update the same data. I have gotten [quoted text clipped - 16 lines] > > TIA I've seen this happen (rarely) before. It is some type of corruption in your DB. Unfortunately, Compact and/or Repair won't fix it. To cure it you need to create a new blank databse, then import all of the tables (data and definition) from the original. Rename the original (so you have a copy in case something went wrong) then rename the new one to the original name. Now you should be able to run Compact. I suspect you have memo field errors in one or more tables - try creating a blank database and import everything from the old one - you will probably receive an error message about being unable to copy all data (don't remember exact message) - you usually only lose one record. > I have a access97 mdb that will not allow me to compact. It tells me > > that two users are tying to update the same data. I have gotten [quoted text clipped - 16 lines] > > TIA |
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.