Grrrr!! Access 2003 Database Corrupting On Exit

suzanne

I have a database that had been stable until 3 weeks ago. The Access
2003 database occasionally (a couple of times a week) gets corrupted
when the last user exits the application. At least, that's what I'm
assuming since they get no error while working.

If I make a copy of the database prior to the last user logging out,
that copied DB remains undamaged. If I attempt to log back the
original DB in once everyone is out, I get the dreaded "Unrecogniz ed
file format" error message. The frustrating part is that I can't make
it happen consistently.

This customer is running on Windows 2000 SP4 and Access 2003. The
database in on a networked server.

By in large, their PCs are configured the same, except that one has a
higher version of: MSEXCL40.DLL (v 4.00.9025.0), MSTEXT40.DLL (v
4.00.9401.0) and MSXBDE40.dll (v 4.00.9025.0) Jet libraries.

I'm really pulling my hair out with this one. Has anyone run across a
similar problem? Any ideas of what could be causing the corruption?

Mar 21 '07 #1

Subscribe Reply

1999

Tony Toews [MVP]

su*****@dataacc ent.com wrote:

>I have a database that had been stable until 3 weeks ago. The Access
2003 database occasionally (a couple of times a week) gets corrupted
when the last user exits the application. At least, that's what I'm
assuming since they get no error while working.

No, this is an invalid assumption. If a user is in a database when it is flagged for
corruption by another user the first user won't notice anything until they exit and
go back in. Access only checks for that flag when Access opens the MDB.

>If I make a copy of the database prior to the last user logging out,
that copied DB remains undamaged. If I attempt to log back the
original DB in once everyone is out, I get the dreaded "Unrecogniz ed
file format" error message. The frustrating part is that I can't make
it happen consistently.

Corruption seldom happens consistently.

>By in large, their PCs are configured the same, except that one has a
higher version of: MSEXCL40.DLL (v 4.00.9025.0), MSTEXT40.DLL (v
4.00.9401.0) and MSXBDE40.dll (v 4.00.9025.0) Jet libraries.

Now this is interesting because according to the Microsoft's DLL Help Database
http://support.microsoft.com/dllhelp/ those DLLs are for Windows Server 2003 SP1.
That said that DLL Help database is sometimes rather out of date.

MSEXCL40.DLL is for "Microsoft Jet Excel Isam" and is for Microsoft Windows Server
2003 Service Pack 1.

MSTEXT40.DLL - Microsoft Jet Text Isam - Microsoft Windows Server 2003 Service Pack 1

MSXBDE40.dll - Microsoft Jet xBASE Isam - Microsoft Windows Server 2003 Service Pack
1

That said it doesn't really matter as those DLLs are not part of Jet itself. The
important DLL there is MSJET40.DLL. Are the versions consistent there?

>I'm really pulling my hair out with this one. Has anyone run across a
similar problem? Any ideas of what could be causing the corruption?

For more information on corruption including possible causes, determining the
offending PC, retrieving your data, links, official MS KB articles and a list of
vendors who state they can fix corruption see the Microsoft Access Corruption FAQ at
http://www.granite.ab.ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Mar 22 '07 #2

suzanne

On Mar 21, 5:25 pm, "Tony Toews [MVP]" <tto...@teluspl anet.netwrote:

suza...@dataacc ent.com wrote:
I have a database that had been stable until 3 weeks ago. The Access
2003 database occasionally (a couple of times a week) gets corrupted
when the last user exits the application. At least, that's what I'm
assuming since they get no error while working.

No, this is an invalid assumption. If a user is in a database when it is flagged for
corruption by another user the first user won't notice anything until they exit and
go back in. Access only checks for that flag when Access opens the MDB.

If I make a copy of the database prior to the last user logging out,
that copied DB remains undamaged. If I attempt to log back the
original DB in once everyone is out, I get the dreaded "Unrecogniz ed
file format" error message. The frustrating part is that I can't make
it happen consistently.

Corruption seldom happens consistently.

By in large, their PCs are configured the same, except that one has a
higher version of: MSEXCL40.DLL (v 4.00.9025.0), MSTEXT40.DLL (v
4.00.9401.0) and MSXBDE40.dll (v 4.00.9025.0) Jet libraries.

Now this is interesting because according to the Microsoft's DLL Help Databasehttp://support.microso ft.com/dllhelp/those DLLs are for Windows Server 2003 SP1.
That said that DLL Help database is sometimes rather out of date.

MSEXCL40.DLL is for "Microsoft Jet Excel Isam" and is for Microsoft Windows Server
2003 Service Pack 1.

MSTEXT40.DLL - Microsoft Jet Text Isam - Microsoft Windows Server 2003 Service Pack 1

MSXBDE40.dll - Microsoft Jet xBASE Isam - Microsoft Windows Server 2003 Service Pack
1

That said it doesn't really matter as those DLLs are not part of Jet itself. The
important DLL there is MSJET40.DLL. Are the versions consistent there?

I'm really pulling my hair out with this one. Has anyone run across a
similar problem? Any ideas of what could be causing the corruption?

For more information on corruption including possible causes, determining the
offending PC, retrieving your data, links, official MS KB articles and a list of
vendors who state they can fix corruption see the Microsoft Access Corruption FAQ athttp://www.granite.ab. ca/access/corruptmdbs.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab. ca/accsmstr.htm

Many thanks Tony. This was extremely useful information. You rule!!
S.

Mar 29 '07 #3

Similar topics

435

VB.Net connecting Access 2003 Database

by: Guillermo | last post by:

Gentlemen, I have a VB6 Project. Works fine in my PC, but once uploaded to my website it can't connect to my Access database. Questions: 1. Can VB.net connect with Access 2003 databases hosted in the same website?. 2. If so, how easy it is to convert the VB6 Project (has several forms, but very little and simple code) to VB.Net?. Please...

.NET Framework

41160

Access 2003 - database file limit

by: Mike | last post by:

Hi, I was wondering if the database file size limit was still 2GB in Access 2003? Does anyone out there who has been beta testing or a mvp have any info on this? Regards Mike

Microsoft Access / VBA

12307

Automatic backup's Access 2003 database

by: Andy Davis | last post by:

Hi Is there any way of carrying out an automatic daily/weekly backup of an Access 2003 database without the user having to manually remember to do it themselves? Thanks in advance. Dawn

Microsoft Access / VBA

2577

Access 2003 database will not open using Access 2002

by: Bugs | last post by:

Hi everyone. I am trying to open a database which works fine using Access 2003, but when trying to open it on another PC that has Access 2002 I get the following error "This database is unrecognised file format, it may have been created with a later version of Access, upgrade to a later version..." Could anyone please help to resolve...

Microsoft Access / VBA

2646

Access 2003 Database link on web

by: Heather | last post by:

I created a link on the web page to a access 2003 Database and it prompts security messages, it acts like it tries to open, but it gets hung up and i guess times out. I changed the macro security setting to low. No difference. Please advise.

Microsoft Access / VBA

2856

Using Secured MS Access 2003 Database

by: pbala | last post by:

hello, I created the user level security for one MS Access 2003 database.It created one Shortcut file in Desktop. Now I want to share the database with my company workers. How i will share the Database? Thanks...

Microsoft Access / VBA

1400

splitting a secured access (2003) database

by: buddyr | last post by:

Hello, I have an access database ( access 2003) that has user level security on it. I am reading a paper that says I don't have to use wizard to split database- that I can manually split database- the first step to the process is create a copy of database. My database has user level security on it- I can only open it thru a shortcut icon that...

Microsoft Access / VBA

1777

Automate closing an Access 2003 database

by: peter1952 | last post by:

I would like to automate closing an Access 2003 database at the end of running a macro. How can I do this?

Visual Basic 4 / 5 / 6

3272

MS Access 2003 Database as exe file

by: newphpcoder | last post by:

Good day! I created a database using MS Access 2003 and I want it make to MDE file but when I click the Make MDE File I got the pop up message like this: You cannot create a Microsoft Offiece Access ADE or MDe file from a database saved in Microsoft Office Access - 2000 format Convert the database to the current version of Microsoft...

Microsoft Access / VBA

7520

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...

General

7450

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...

Windows Server

7720

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7470

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...

Windows Server

7809

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

6043

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5088

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3481

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

763

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General