473,735 Members | 11,066 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Access 2002 unexpectedly quits and Catastrophic Failure messages

The Reps team have been experiencing that Access 2002 unexpectedly
quits
while working and also lots of Corruption Failures and "Record lock
can not
update" messages since the upgrade from Windows 2000 and Access 200 to
Windows XP and Access 2002 (XP) was done.
Now, they are working and at anytime in anywhere of the application
access
unexpectedly quits with no error messages and the info that was being
entered
is lost.

all computers have a standard configuration with the latest services
packs,
Microsoft Windows XP SP2 and Microsoft Office 2002 (XP) SP3, Microsft
Jet
4.0.8618.0, y have also check all the references and they are good.

Here are the references:
-Visual Basic for applications
-Microsoft Access 10.0 Object Library
-Microsoft Office 10.0 Object Library
-Microsoft Office XP Web Components
-Micrfosoft ActiveX Data Objects 2.8 Library
-OLE Automation

I heard something about Opportunistic locking if you disable it
(Oplocks) on
the server may reduce the risk of data corruption.

This problems occurred in an .mde file, but i also have experienced the
same
problem and i am working with the .mdb file

I've been dealing with this problem since 7/12/06 (more than 2 weeks)
doing
lots of different things like changing references, disabling and
enabling the
"open databases using record locking", compact and repair, migrate
database
to access 2002, contacting Microsoft co (The suggestions they gave did
not work)., etc.

Sometimes I have the opportunity to debug and the error usually comes
in
the next part (testing with a total of 3 users saving a new contact
record each user and saving all simultaneously at once), after the
other users are done saving when i got the error message then click on
cotinue process and it saves with no problem.

Code:

Sub WriteAuditlog(t xtOperation, txtTableName, txtFieldName, frefnum,
OrgValue, CurValue)
Dim rstAudit As ADODB.Recordset
Dim fsql As String
On Error GoTo Err_WriteAuditl og

Set rstAudit = New ADODB.Recordset
Set rstAudit.Active Connection = CurrentProject. Connection
rstAudit.Cursor Type = adOpenKeyset
rstAudit.LockTy pe = adLockPessimist ic
fsql = "Select * from AuditTable"

rstAudit.Open fsql =============== =======IT WILL BREAK HERE

rstAudit.AddNew

When i continue the execution after the message catastrophic failure it
saves the contact record with no problem.
Does anybody know what could be happening? if you need any more
information please let me know. Thanks for your replies, any help is
appreciated!

Jul 28 '06 #1
2 6253
Not sure exactly what's happening, but some generic suggestions:

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\m saccess.exe" /decompile
"c:\MyPath\MyDa tabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.

Now, some more specific ones.

If the form that triggers the crash has a subform that has a multi-table
query as its RecordSource, this could be an Access bug:
1. Open the main form in design view.
2. Clear the Link Master Fields and Link Child Fields properties.
3. Save. Close.
4. Open the subform in design view, and add a text box for the foreign key
fields (the ones previously named in Link Child Fields.)
5. Save. Close.
6. Open the main form, again, and restore the Link Master Fields and Link
Child Fields properties.
Typically the foreign key fields are not shown on the form, so their data
type is AccessField, and the bug seems to be with this type. By adding a
text box, you avoid the bug.)

Other alternatives would be to use an append-only recordset for the target,
or a DAO recordset, or execute an Append query instead of opening the
recordset.

You may be able to remove the OLE and Web Components libraries. Access gives
you those by default; remove them if you are not using them.

HTH

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Frav" <fr**********@h otmail.comwrote in message
news:11******** **************@ s13g2000cwa.goo glegroups.com.. .
The Reps team have been experiencing that Access 2002 unexpectedly
quits
while working and also lots of Corruption Failures and "Record lock
can not
update" messages since the upgrade from Windows 2000 and Access 200 to
Windows XP and Access 2002 (XP) was done.
Now, they are working and at anytime in anywhere of the application
access
unexpectedly quits with no error messages and the info that was being
entered
is lost.

all computers have a standard configuration with the latest services
packs,
Microsoft Windows XP SP2 and Microsoft Office 2002 (XP) SP3, Microsft
Jet
4.0.8618.0, y have also check all the references and they are good.

Here are the references:
-Visual Basic for applications
-Microsoft Access 10.0 Object Library
-Microsoft Office 10.0 Object Library
-Microsoft Office XP Web Components
-Micrfosoft ActiveX Data Objects 2.8 Library
-OLE Automation

I heard something about Opportunistic locking if you disable it
(Oplocks) on
the server may reduce the risk of data corruption.

This problems occurred in an .mde file, but i also have experienced the
same
problem and i am working with the .mdb file

I've been dealing with this problem since 7/12/06 (more than 2 weeks)
doing
lots of different things like changing references, disabling and
enabling the
"open databases using record locking", compact and repair, migrate
database
to access 2002, contacting Microsoft co (The suggestions they gave did
not work)., etc.

Sometimes I have the opportunity to debug and the error usually comes
in
the next part (testing with a total of 3 users saving a new contact
record each user and saving all simultaneously at once), after the
other users are done saving when i got the error message then click on
cotinue process and it saves with no problem.

Code:

Sub WriteAuditlog(t xtOperation, txtTableName, txtFieldName, frefnum,
OrgValue, CurValue)
Dim rstAudit As ADODB.Recordset
Dim fsql As String
On Error GoTo Err_WriteAuditl og

Set rstAudit = New ADODB.Recordset
Set rstAudit.Active Connection = CurrentProject. Connection
rstAudit.Cursor Type = adOpenKeyset
rstAudit.LockTy pe = adLockPessimist ic
fsql = "Select * from AuditTable"

rstAudit.Open fsql =============== =======IT WILL BREAK HERE

rstAudit.AddNew

When i continue the execution after the message catastrophic failure it
saves the contact record with no problem.
Does anybody know what could be happening? if you need any more
information please let me know. Thanks for your replies, any help is
appreciated!

Jul 29 '06 #2
I believe I am having a similar problem with an Access MDB. I have a
process that uses a DAO recordset to get data from ODBC-attached
sources. Occasionally it terminates without warning. I don't have the
corruption failure or lock errors, but I'm only querying the data in
this procedure. It fails whether the client is Win XP SP2 or Win
Server 2003 SP1. I haven't tested on other platforms.

I've rewritten the procedure to use ADO instead, and now get the
trappable error -2147418113 with description 'Catastrophic failure'.
If I put in error handling to resume on that error, it continues
without problems.

In my case, I get this issue primarily at one of the two sites I
support. They should be parallel environments (both Win Server 2003
SP1 with XP SP2 clients running Oracle 10g R2, using Oracle's ODBC
driver, Access 2003, same MDB, etc.), so I'm trying to find what is
different at the site that doesn't have the issue.

For a work-around, you might try this article:
http://support.microsoft.com/default.aspx/kb/187942

Have you found anything out on this issue? If so, please share it.

Terry
Frav wrote:
The Reps team have been experiencing that Access 2002 unexpectedly
quits
while working and also lots of Corruption Failures and "Record lock
can not
update" messages since the upgrade from Windows 2000 and Access 200 to
Windows XP and Access 2002 (XP) was done.
Now, they are working and at anytime in anywhere of the application
access
unexpectedly quits with no error messages and the info that was being
entered
is lost.

all computers have a standard configuration with the latest services
packs,
Microsoft Windows XP SP2 and Microsoft Office 2002 (XP) SP3, Microsft
Jet
4.0.8618.0, y have also check all the references and they are good.

Here are the references:
-Visual Basic for applications
-Microsoft Access 10.0 Object Library
-Microsoft Office 10.0 Object Library
-Microsoft Office XP Web Components
-Micrfosoft ActiveX Data Objects 2.8 Library
-OLE Automation

I heard something about Opportunistic locking if you disable it
(Oplocks) on
the server may reduce the risk of data corruption.

This problems occurred in an .mde file, but i also have experienced the
same
problem and i am working with the .mdb file

I've been dealing with this problem since 7/12/06 (more than 2 weeks)
doing
lots of different things like changing references, disabling and
enabling the
"open databases using record locking", compact and repair, migrate
database
to access 2002, contacting Microsoft co (The suggestions they gave did
not work)., etc.

Sometimes I have the opportunity to debug and the error usually comes
in
the next part (testing with a total of 3 users saving a new contact
record each user and saving all simultaneously at once), after the
other users are done saving when i got the error message then click on
cotinue process and it saves with no problem.

Code:

Sub WriteAuditlog(t xtOperation, txtTableName, txtFieldName, frefnum,
OrgValue, CurValue)
Dim rstAudit As ADODB.Recordset
Dim fsql As String
On Error GoTo Err_WriteAuditl og

Set rstAudit = New ADODB.Recordset
Set rstAudit.Active Connection = CurrentProject. Connection
rstAudit.Cursor Type = adOpenKeyset
rstAudit.LockTy pe = adLockPessimist ic
fsql = "Select * from AuditTable"

rstAudit.Open fsql =============== =======IT WILL BREAK HERE

rstAudit.AddNew

When i continue the execution after the message catastrophic failure it
saves the contact record with no problem.
Does anybody know what could be happening? if you need any more
information please let me know. Thanks for your replies, any help is
appreciated!
Aug 18 '06 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
2516
by: Thomas Baier | last post by:
Hi there, I'v got a little program generating coincidental lists. It crashes with memory access failure, but not always at the same time. If I start the programm using valgrind it always crashes after sorting the first list with the following messages: thomas@linux:~/Info/C++> valgrind list /usr/bin/valgrind: line 106: exec: list: not found
1
2275
by: Mike Ridley | last post by:
I am trying to create a new query using 3 linked tables. As soon as I add the third table to the design grid Access crashes. I have looked in the newsgroup and find that there have been problems with linked tables and Access 2000 but the threads are dated about 3 years ago. I am running XP Home Edition Version 2002 SP1 and Access 2002 (10.2627.2625). I have checked on the Microsoft Upgrade site and although upgrades are available they...
5
7864
by: j.mandala | last post by:
Someone is trying to run my Access 2002 database under Access 2003. He has had a number of problems: 1) i used the MSComCt2.ocx for it's Date and Time picker. I can't find it under 2003. Do I need to send it to them? 2) I have a function to fill a table with values, that store the page and column numbers of a display of staff members. I had him check the link to Microsoft DAO 3.6 Object Library under references, but it still won't...
8
1950
by: David Kistner | last post by:
I'm fairly new to Access (I've worked with Oracle and MySQL in the past). I was asked to build an application for a small office and told that I had to use Access 2002. I was VERY uncomfortable with this, but went ahead anyway. So two weeks ago we rolled out the new system and I'm still wondering how robust Access is......I know it's not in the same league as Oracle, but at the same time this isn't a real big application. But I can't...
0
2195
by: miqbal | last post by:
IM getting this error when i try to run Teecharts ActiveX control in asp.net environment can some one help me in it Regards Moid Iqbal Catastrophic failure Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information
3
470
by: Juande | last post by:
Hello, I've a working application made with Visual Studio .Net 2003 and SQL Server 2000 SP3, this application runs on several pc stations with Windows XP SP2 installed. When an user is using the application, it's quits unexpectedly without any previous advice or error message, I'm trying solve this problem for a long time but I cannot find a solution. Please, Anybody had a similar expirience and finally got solve it?, please let me...
2
8442
by: jdanoz | last post by:
Hello, i have a vb.net project with a reference to an ActiveX object (ocx). If i try to use the ocx from vb6 project (adding the reference) it works ok (using CreateObject). In vb.net, the CreateObject works ok, the object gets initialized...
4
1987
by: FishingScout | last post by:
I am re-writing an MS VC++ 6.0 application in Visual Studio 2005 VB.NET. In order for my new application to communicate with some hardware (an RFID reader) I need to communicate with a DLL that was written in MS VC++ 6.0. I have found some excellent discussions that have helped me define the structures to marshal the data between the unmanaged and managed code. My problem is that my application is not working correctly. The result is...
1
8103
by: tk121 | last post by:
Hey all - I have some unmanaged code that I'm calling into with C# .NET 2.0, and everything works flawlessly in the debugger, but as soon as I run the application as a standalone executable it unexpectedly quits without throwing any exceptions. Even if I start the executable in the debugger it works okay. To see the failure, I need to start the application and then attach the debugger to the process. The function call will work okay twice...
0
8962
marktang
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 usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
8785
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9463
Oralloy
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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9327
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9251
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 most users, this new feature is actually very convenient. If you want to control the update process,...
0
6049
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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4559
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4822
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3273
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.