-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Whichever query is highlighted when you click the Design icon/button
is the query that is causing the Access crash. This means the query
object is probably corrupted. Try running the compact/repair (Acc2000
& >) on the Tools menubar: Tools > Database Utilities >
Compact/Repair. If that doesn't work you'll have to delete and
recreate the query. Before you delete the query you can, sometimes,
get the query's SQL statement by doing this in the immediate (debug -
Ctrl-G) window (.mdb files):
? currentdb.querdefs("queryname").sql
Save the result of this command, if it doesn't crash Access, in a text
file (Notepad) or in the clipboard (highlight SQL statement & hit Ctrl
C). Delete the query. Compact the db. Recreate the query. Switch
to SQL View and paste the SQL statement into the SQL View. Test the
query.
HTH,
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQCGPn4echKqOuFEgEQI7JwCfWQjSdfNxfWohx6FPuGU6MgNM0/UAoKRK
uGMIjgqdvfymAbmVW2ZPc/Yf
=8EhI
-----END PGP SIGNATURE-----
