473,289 Members | 1,848 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,289 software developers and data experts.

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(txtOperation, txtTableName, txtFieldName, frefnum,
OrgValue, CurValue)
Dim rstAudit As ADODB.Recordset
Dim fsql As String
On Error GoTo Err_WriteAuditlog

Set rstAudit = New ADODB.Recordset
Set rstAudit.ActiveConnection = CurrentProject.Connection
rstAudit.CursorType = adOpenKeyset
rstAudit.LockType = adLockPessimistic
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 6227
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\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.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**********@hotmail.comwrote in message
news:11**********************@s13g2000cwa.googlegr oups.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(txtOperation, txtTableName, txtFieldName, frefnum,
OrgValue, CurValue)
Dim rstAudit As ADODB.Recordset
Dim fsql As String
On Error GoTo Err_WriteAuditlog

Set rstAudit = New ADODB.Recordset
Set rstAudit.ActiveConnection = CurrentProject.Connection
rstAudit.CursorType = adOpenKeyset
rstAudit.LockType = adLockPessimistic
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(txtOperation, txtTableName, txtFieldName, frefnum,
OrgValue, CurValue)
Dim rstAudit As ADODB.Recordset
Dim fsql As String
On Error GoTo Err_WriteAuditlog

Set rstAudit = New ADODB.Recordset
Set rstAudit.ActiveConnection = CurrentProject.Connection
rstAudit.CursorType = adOpenKeyset
rstAudit.LockType = adLockPessimistic
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
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...
1
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...
5
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...
8
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...
0
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...
3
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...
2
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...
4
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...
1
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...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

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.