Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 18th, 2006, 01:00 PM
Registered User
Join Date: Nov 2003
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access 2000 database file locked up

I know this is an old and common problem for many people. In fact, I have had this problem for a long time but still have not fixed.

My customer was using our VB6 application with Access 2000 database on a standalone industrial machine. This morning she could not start the application and got an 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 prompted her to search for any ldb files but she could not find any in the whole hard drive. Then she emailed me the database file.

Of course, I cannot not open it so I cannot do Compact and Repair through Access tool. Then I tried using VB code to repair it but I still got the same error.

Here are my questions:

1. How to fix the database? Any tools or third party software I can use?

2. What caused the crash?

Please help soon. Thanks.

Old October 19th, 2006, 10:38 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

You don't need to open the database to compact and repair. Open Access without a file, then go to Tools > Database Utilities > Compact and Repair, and then point to the database file. See if that works.

Yu can also create a new file and link to the wrecked one and see if you can carry out any actions on the linked tables to see if you get record locking issues.


Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL 2000 database / text file / binary file pallone Javascript How-To 3 January 28th, 2005 01:26 PM
ADE file in Access 2000 <---> Access XP ginoitalo Access 3 April 14th, 2004 09:06 PM
Issues Connecting to an Access 2000 Database... Jonny ADO.NET 1 February 11th, 2004 09:54 AM
Connecting to an Access 2000 database Jonny .NET Web Services 0 November 10th, 2003 03:13 PM
Moving Access 2000 database server lmcharl Access 1 June 21st, 2003 09:58 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.