Access closes when query run

G

Guest

i am running a query that simply links several odbc tables and queries. when
i run the query, access shuts down and the program exits entirely. all i see
then is my desktop. any ideas what could be happening?
 
J

John W. Vinson

i am running a query that simply links several odbc tables and queries. when
i run the query, access shuts down and the program exits entirely. all i see
then is my desktop. any ideas what could be happening?
Click to expand...

Some error in either your code, the SQL of the query, or your installation of
Access.

Please post your code and the SQL of the query. Have you tried compacting and
repairing the database?

John W. Vinson [MVP]
 
G

Guest

must have been the code because when i rewrote the entire query, the problem
was solved
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query links to SQL server and mdb table 1
Query slow after being renamed 1
Make table query won't run but Select will 3
Query Too Complex 8
Access 2010 append query to SQL is very slow 0
Query is too complex after install Access 2007 SP 2 !? 25
Parameter Query Won't Run 0
SQL Server Login requesting password when query is run. 4

Top