Applicatino closes when execute query

[chenning \(removethis\)]

Very strange probblem in Access 97... For one very simple
query out of dozens in the same database, when I run the
query, the entire application closes. It doesn't show the
results or prompt me in any way -- it just close the
entire thing. Anyone run into this problem or have any
advice?

 

[[MVP] S. Clark]

What is your data setup? Is your data in the same mdb, Linked, ODBC, or
other?

If linked table or ODBC, ensure that links are all refreshed and valid.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-