If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access closes when query run
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? |
#2
|
|||
|
|||
Access closes when query run
By what means are you initiating the start of the query?
Button on a form? A macro? -- KARL DEWEY Build a little - Test a little "tcek" wrote: 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? |
#3
|
|||
|
|||
Access closes when query run
On Tue, 21 Aug 2007 13:52:02 -0700, tcek
wrote: 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? 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] |
#4
|
|||
|
|||
Access closes when query run
must have been the code because when i rewrote the entire query, the problem
was solved "John W. Vinson" wrote: On Tue, 21 Aug 2007 13:52:02 -0700, tcek wrote: 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? 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] |
Thread Tools | |
Display Modes | |
|
|