MS Access for Windows problem

[Birdy]

Upon closing a database using Access 2000 Runtime, I am getting the following error: -

Microsoft Access for Windows has encountered a problem and needs to close.

This happens just as I am closing the database down and not at any other time. It also only happens on Access Runtime.

Can anybody please help?

 

[WindSailor]

The only suggestion that I can come up with is to make sure the record(s) that you have worked with are indeed saved and not left in the edit mode.
Does this happen if you open the app and then immediately close it?

 

[Birdy]

All the records are saved automatically upon exiting the work form.

This does happen if you open the db and then close it immediately.

 

[neileg]

You have done a repair and compact, I presume.

 

[Birdy]

Yes, i have done a compact and repair. Also, this works OK with my full version (on XP) and my copy of runtime (on 98). It just seems to be this machine that we are testing it on.

 

[ghudson]

Ensure you close all record sets and "set" anything that you have "set" to nothing.

RS = Nothing

Does the db compile?

Can you check for a missing reference on the runtime PC?

 

[Birdy]

Sorry .. No recordsets are in use within the db.
Runtime does not allow access into the code.

 

[WindSailor]

You don't have the .mdb file, only the runtime or .mde file?

Edit-------------------------------------

Ok... not on that machine... a little slow... no comment please...
What about different screen resolutions, windows update?

 

[Birdy]

I have checked the screen resolution, Win XP SP2 is installed with latest updates. Our desktop guys reckon it's access so won't look into it. TYPICAL.

 

[WindSailor]

Try trapping the error when closing the app and see what you get...

 

[ghudson]

I trust that all of your subs and functions have proper error handling. mdb files opened with the runtime version of Access will shut down if a runtime error happens and the error is not properly trapped.

 

[Birdy]

All error hadling is trapped, No error occurs when using full version on another PC.
Can't try on another PC with XP and Runtime, as this is the only PC available.
I have compared libraries and other files and these are all OK.