Query causes Access to close

  • Thread starter Thread starter P Rosenkrans
  • Start date Start date
P

P Rosenkrans

I have an Access database created on a Windows XP pro
machine. The database was created in Office XP but the
default file format is Access 2000. The database works
fine when accessed by users with Office XP but some users
with Office 2000 will run some of the queries and access
will end, no error messages or anything. It just goes out
to the desktop. I have checked the Knowledge Base and
have drawn a blank. Any help would be greatly appreciated.
 
I have the similar experience.

I believe the query (or queries) you have built up were
corrupted or the tables were the queries are created were
corrupted.

I suggest the following :
1. backup all your tables and databases
2. repair and compact your tables and databases
3. delete the affected queries
4. repair and compact your tables and databases again
5. recreate those queries that you have deleted earlier
from scratch

I hope the above helps
 
Back
Top