How do I find where MS Access Error logs are on my computer?

[MikeFL]

I often get the following error message on my computer screen when I’m filtering a form and I leave the cursor in one of the filtered field’s (MSACCESS .exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created. and I click the filter command button.

I’ve looked through MS Access help menu and can’t find how to view this log. Does anyone know where I can find this log file on my computer? What is its name? And what will it tell me, is it easily understood?

 

[MikeFL]

This is a repeated request for help!

I often get the following error message on my computer screen when I’m filtering a form and I leave the cursor in one of the filtered field’s (MSACCESS .exe has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created. and I click the filter command button.

I’ve looked through MS Access help menu and can’t find how to view this log. Does anyone know where I can find this log file on my computer? What is its name? And what will it tell me, is it easily understood?

 

[danvlas]

Since it will be closed by Windows, it's a system error. So you have to look for Windows error logs.

But where...that I don't know. Normally it should be a large file, as Windows is very good at generating errors...

Anyway, if it has the same format as when you click 'Details' in a 'This program has performed an illegal operation and will be shut down' box, don't bother...

Try a decompile of your database:

Make a back-up copy of the database.
Start-Run
msaccess.exe /decompile "C:\Path\Database.mdb"
Then compile and compact it.

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[MikeFL]

Danvlas:

Thanks for the response.

I’ll try what you suggested and if I still can’t find it I will as Microsoft.

 

[evalesthy]

Danvlas is right - you are probably not going to get anything meaningful out of the error log. I too, have never found it and doubt that it would tell you much even if you could read it. The suggestion to decompile is the best advice I can think of. Another possibility is to create a new blank database and import all objects (tables, queries, forms, etc.) into the new database and see if your problem goes away. Good luck.

 

[hwkranger]

You can view the log at:

Control Panel, Administrative Tools, Event Viewer, Application - you can view there all the the application errors for any applications.

sometimes it is helpful. Click on the microsoft reference it gives you and it'll give you any known microsoft answers to the problem.

Hope this helps!

Randall Vollen
National City Bank Corp.

Just because you have an answer - doesn't mean it's the best answer.

 

[MikeFL]

Daniel:

FYI:
I found the problem, not from looking at error logs or decompiling the database as you suggested.

I found that it only happened when I had the mouse cursor in the field I’m going to filter on. Once I got out of that field and applied the filter NO errors occurred. I don’t know if I found an Access bug or what!

Thanks for your help and suggestions anyway!