Access suddenly closes

[karlvs]

What would cause Access to suddenly close without warning while busy with a query?

No error messages, nothing! The query is a fairly big one that normally takes about 6 minutes to run, but has had no problem with it for a number of years. A new drive used for back-up purposes was recently fitted to my PC which now has 3 internal hard drives.

Could this problem be caused by a bad memory handling configuration? The original setup that worked before may have been changed when the new drive was installed. The XP Page File size for example may have been changed.

Any advice would be much appreciated.

 

[Pat Hartman]

I'm sorry I don't have any suggestions but your question brought me back to Win 95 and Access 2.0 linked to Sybase tables. I had three queries that had quite peculiar effects:
One was called the automatic reboot. When I ran it, the PC rebooted. Another was called the DOS prompt because when I ran it, I dropped out of Access and out of Windows to the DOS prompt. And the third brought on the blue screen of death.

The problems were all caused by a flakey Sybase ODBC driver. A driver from a different source finally fixed the problem. I doubt that is your problem but it is something to start with.

 

[karlvs]

Thanks for your input -- I tried all kinds of solutions and eventually discovered that one of the tables appeared to have corrupt data that must have caused the problem. I used Compact and Repair after archiving as much older data as I could. That left about 40 records with ####### instead of data in their fields. I deleted those and now I'm back in business!

Till next time...

Magnon