ODBC Failure In JOIN Query ??? (BUT....)

  • Thread starter Thread starter kev100 via AccessMonster.com
  • Start date Start date
K

kev100 via AccessMonster.com

I have a query that is simply a combination of 3 other queries (joined by 1
common field in each).

Each of the 3 "sub queries" will execute fine, Individually....

But....that final query which simply combines them all will display an ODBC
failure error.

I'd always assumed that if each individual query ran okay....the query which
combines them should not get such a data-access related error (since the core
data is already being successfully accessed).

Has anyone else experienced this and found a solution?

Thanks very much
 
To follow up....

This had to do with some sort of shared access violation.

Another 2-3 apps were accessing the same table at the same time.

I'm not sure why this would cause such an error (the problem was actually a
sporadic one...it would usually fail, but occasionally work).

Now that those other apps are not access the table...the error does not occur.


Thanks
 
Back
Top