Access 2002 unexpectedly quits !!

[easycode]

The Reps team have been experiencing that Access 2002 unexpectedly quits while working and other problems since the uppgrade from Windows 2000 to Windows 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.

Does anybody know what could be happening?

Thanks for your replies, any help is appreciated!

 

[easycode]

i heard something about Opportunistic locking if you disable it (Oplocks) on the server may reduce the risk of data corruption. Does anybody knows anything about it?

 

[instructorTek]

Hi place the following code in the on close event of the forms and let an error message be generated:

On Error GoTo Err_Check


Exit_Err_Check:
Exit Sub

Err_Check:
MsgBox Err.Description
Resume Exit_Err_Check

 

[missinglinq]

Is this db run aas an MDB file or a MDE file?

The Missinglinq

There's ALWAYS more than one way to skin a cat!

 

[GarstonMassive]

In my experience this is most definetely a References problem.

You say all the refrences are good - which ones have you got selected?

Also does the DB compile OK?

 

[easycode]

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

This are the references:
-Visual Basic for applications
-Microsoft Access 10.0 Object Library
-Microsoft Office 10.0 Object Library
-Microsoft Forms 2.0 Object Library
-Micrfosoft ActiveX Data Objects 2.6 Library
-OLE Automation

if you need any more information please ket me know, Thanks for your replies.