Gary Kjos
garykjos at gmail.com
Fri Sep 14 16:08:46 CDT 2012
Hope you have a backup. This isn't good if Jetcomp can't fix it. Create a new MDB and try to import what you can. Additional info I found - you probably did too.... http://support.microsoft.com/kb/182867 http://www.pcreview.co.uk/forums/access-error-3197-and-jetcomp-exe-error-error-compacting-database-t3168770.html http://www.zimbio.com/Access+Repair/articles/Ch9qV2w_4mL/Resolving+Jet+Database+Engine+Error+3197 http://www.myaccesstips.com/Errors/Locks.htm Here's a company that has a repair tool..... http://www.cimaware.com/main/products/accessfix.php?gclid=COipm_78tbICFTN0Mgod2G4AQg I've not used it. Good luck. GK On Fri, Sep 14, 2012 at 3:44 PM, Francisco Tapia <fhtapia at gmail.com> wrote: > Hello again gang, > It's been a long time since I've needed to work on an Access Database, > and the current error I'm running into is that of the Error #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. > > I'm not able to open up the database to perform a compact and repair. I'm > running Access 2003 on my machine and tried running the JetComp against > this db but to no avail... I've googled but really didn't get any hits on > what could be done to recover... > > any ideas? > > -Francisco > -------------------------- > You should follow me on twitter here <http://twitter.com/seecoolguy> > Blogs: SqlThis! <http://bit.ly/sqlthis> | XCodeThis!< > http://bit.ly/xcodethis> > > <http://db.tt/JeXURAx> > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- Gary Kjos garykjos at gmail.com