Wrox Programmer Forums
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access 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 June 13th, 2003, 05:37 AM
Authorized User
 
Join Date: Jun 2003
Posts: 15
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to james_sellwood
Default MDB file un-openable

I have an Access mdb file which cannot be opened. When it is double clicked on Access opens and then a pop-up error message appears (twice) stating that:
Quote:
quote:The Microsoft jet database engine stopped the process because you and another user are attempting to change the same data at the same time. (OK / Help)
I have looked online and this seems to be possibly caused by #error data within one of the database tables. I cannot get into the database to check the table and it's content. I found references to a utility called jetcomp.exe which is provided to compact and repair database files from outside of Access. When I run this and try to repair the database into a fresh blank one I get the error message
Quote:
quote:Error compacting database
Does anyone know how i might get into the database file. There are no other users trying to use it and other database files work fine on the same machine. This error occurs on all new copies made of the file no matter what machine they are tested on.

Thanks in advance for any help / ideas given. They would be useful.


--------------------
:) James Sellwood :)
--------------------
__________________
--------------------
James Sellwood
--------------------
 
Old June 13th, 2003, 06:58 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Possibly changing the record locking options you have for Access might do something.

Have you tried importing the tables into a new mdb file?
If you can't link through Access, can you link through Excel, or some other program that can take ODBC?

If either of those work, you'll at least get your data.

HTH

Steven



There are 10 kinds of people in the world - those who understand binary - and those with friends
 
Old June 13th, 2003, 07:05 AM
Authorized User
 
Join Date: Jun 2003
Posts: 16
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi,

If I understand ok,

u can try to see if your microsoft system have already opened a process "MSACCESS.EXE" (in Task Manager).
If you have another MSACCESS process, kill him and retry.

If now the file mdb is opened correctly, you must restar your system.
 
Old June 14th, 2003, 07:56 AM
Authorized User
 
Join Date: Jun 2003
Posts: 91
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I would try going into the *.mdb that you created the *.mde from and complie all the code and make a new *.mde.

Kenny Alligood
 
Old June 16th, 2003, 03:29 AM
Authorized User
 
Join Date: Jun 2003
Posts: 15
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to james_sellwood
Default

There was no other process active. I am only using an mdb file (no mde file involved). I could not import the data into Access or Excel.

A colleage of mine found a utility which fixed the mdb file the way jetcomp was supposed to. I think it was called Recover Access. Unfortunately I did loose the forms within the mdb file, but all data and queries were recovered successfully.

Thanks for the advice.

--------------------
:) James Sellwood :)
--------------------





Similar Threads
Thread Thread Starter Forum Replies Last Post
Corrupted mdb file edcaru Access 4 April 19th, 2012 10:38 AM
Creating Access (.mdb) file from ASP mfarooqw ASP.NET 2.0 Basics 1 June 5th, 2007 02:39 AM
Renaming remote mdb file elansolutionsltd Access VBA 7 November 11th, 2005 07:00 AM
icecream07.mdb file bjackman BOOK: Beginning Access VBA 3 December 8th, 2003 08:07 PM
Beginning C# Databases - Can;t open .MDB file saxitalis All Other Wrox Books 0 November 6th, 2003 03:56 PM





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