European Experts Exchange (EEE.org) :: Free Experts PHP MySql Oracle Microsoft Web SQL Delphi


Don't Know :: On standby of sorting :: Access problem - Jet Engine Error 3197 - data corrupt ?
By: FiatLink	Date: 25/05/2005 10:47:07	Points: 20	Status: Answered Quality : Excellent
We have a serious problem with one of our databases. Our IT support thinks that the database is corrupt. Any solution ? Thanks ------------------------------ the ER database cannot be viewed or edited: Access97 issues errors: error: The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (Error 3197) I am the only user on this database, restart PC does not help, other users on another PC have the same problem. link: "C:\Program Files\Microsoft Office 97\Office\MSACCESS.EXE" "F:\TE_Public\ER_Enhanced.mdb" /wrkgrp "F:\TE_Public\ER.mdw" ------------------------------
By: VGR	Date: 25/05/2005 11:04:42		Type : Answer
Hi ;-) I will create an "Access" topic as soon as I've the time. For your problem : the database is indeed corrupted. excerpts from http://www.prd-software.com.au : There are no workarounds for a corrupted database. It must be compacted and repaired in order to work correctly again. It is a good idea to make a backup copy of your database before attempting a compact and repair. Under very limited circumstances the compact and repair process itself can actually damage a corrupt database beyond repair. Microsoft Access has a Repair and Compact database feature. In order to do this, you will first need to connect as "superuser" ("root", "sa" or the like for Access) Access 2000 has a more powerful compact and repair function. If you have a copy of Access 2000 somewhere in your office, it is recommended that you use this version to compact and repair your datababase. Still Corrupted? 1. Microsoft have recently released a repair and compact utility for Access based databases that will fix and compact databases that previous versions could not. If you have tried the methods above for fixing your database, and have been unsuccessful, please download refer to the knowledge base document "Repair and Compact database utility" (use jetcomp.zip) 2. Please ensure that you have downloaded and installed the latest Microsoft Jet Database DLL's. These updated DLL files feature enhanced database compaction and repair functionality. Once you have installed this update, try running the above compact and repair procedures again. (NdVGR : I recommend at least Jet 3.51 ) ------------------ VGR : One of the possible causes would be that you have : All of the forms and sub-forms have the same Properties: Recordset Type: Dynaset (Inconsistent Updates) Record Locks: No Locks The database Options (under Advanced) are set to: Default Open Mode: Shared Default Record Locking: No Locks "Open databases using record-level locking" is checked. you should enable row locking (at worst, table locking) to p^revent concurrent writes to lockup your "database engine" -------------------- Voir aussi la KB microsoft : http://support.microsoft.com/kb/q182867/ -------------- Autres données très intéressantes en provenance de http://www.granite.ab.ca/access/corruption/symptoms.htm: 3197 - "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time" This message most frequently is a symptom of a corrupt memo field. See Locating damage via code for sample code to help you locate the offending memo fields. This error can occur when you are at one form, open another form based on that same table as the previous form, make a change to the data and not refresh the original form. Or similar operations. It can also be a sign of corruption as per ACC: Jet Database Engine 3.x Error Messages Due to Corruption - 182867. As you're using Access 97 then ensure you are at Jet 3.5 SP 3 due to ACC97: Concurrent Appends to a Memo Field Can Cause Corruption and Produces the #deleted Symbol - 235391 --------------------------- My personal advice : I think the "access server" (service?) should be restarted, then checked for health status via its administrative tools ; backed-up, compacted ; and that the table it complained about should have "row locking" or "transactions support" enabled (if not possible, then migrate database to MySql) or at least "table locking" (same remark) Regards

By: VGR	Date: 26/05/2005 10:58:13		Type : Comment
where are you of this problem ?

By: FiatLink	Date: 27/05/2005 08:29:10		Type : Comment
so, the status so far : we were unable to upgrade Access to SR1 due to mangled versions of Office (Microsoft apparently leaves over files=DLLs when you uninstall Office 2000, but doesn't tell you how to fix this situation if ever you can not upgrade Office97 afterwards...) So We were left to having the stupid error about a record that couldn't be read, just at the end of the "compact" operation. ("repair" worked, but we didn't notice any difference either ;-) Being unable to delete this faulty line - contrary to MS "knowledge base" - Access97 kept on crashing any time we access the data, and were considering the "export - fix in text editor - import back" option (recommended by Microsoft, this tells all about the seriousness of Access as a database engine...), But after some reboots (as always... :/ ) we were finally able to delete the line where we found "#Error" (and not "#Deleted" as Microsoft says in its "knowledge base" ;-) Things seem fine now. We are considering moving to a real database engine, like MySql 4 Many many thanks for your amazing knowledge ;-)

Do register to be able to answer

©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page! Post to Plurk Post to Yahoo Buzz Post to Delicious Post to Digg Post to MySpace Post to Ping.fm Post to Reddit Post to StumbleUpon

Contact

page generated in 190.734860 milliseconds

Why Google AdSense ads ?

New Improved Search!