Database Closes Unexpectedly 2

[TimTDP]

I have an Access 2000 Database

Occasionally the database, including Access, simply closes without any error or warning.

I have compiled the database using debug, compile. This ran without any errors.

What could be the cause, and more importantly, how can I prevent it?

 

[Hakala]

No clue about cause, but I'd try importing all the pieces (tables, queries, etc) into a new database "shell." Sometimes that fixes weird errors like this one. Good luck!


Michelle Hakala

http://www.winebird.com/

 

[evalesthy]

I also have been experiencing the same situation (db closing with no error or warning) with one split Access 2000 database for the past few months. I have compiled/decompiled, exported all objects to a new database, compacted repaired, built some new form to replace one or two suspect ones, etc. No luck. If you find anything post back.

 

[missinglinq]

First thing I'd do is to search your VBA code (change from the search default Current Module to Current Project) for:

DoCmd.SetWarnings False

and make sure if you've used this that you turned the warnings back on with DoCmd.SetWarnings True. Something unusual is going on and Access should at least be giving you some kind of error message. Whether the error message will actually clarify your problem is, of course, another story!

Good Luck!

The Missinglinq

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

 

[NvrSaDi]

My experience has generally been identified as an MSAccess.exe error that results either from a code conflict or use of a reserved word in the wrong place.

 

[TimTDP]

Thanks Missinglinq

I have check my code and all warnig messages are turned back on.

Is there an alternative method to turning warnings off/on?
The code between the warnings may be causing the problem!

 

[missinglinq]

Actually there is an alternative method for turning off a couple of warnings, but I don't think they'd apply here.

Tools->Options->Edit/Find->

You can turn On/Off warnings here for Record Changes, Document Deletions and Action Queries.

The Missinglinq

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