Pass through within a pass through query

skwilliams

Registered User.
Local time
Today, 14:46
Joined
Jan 18, 2002
Messages
516
I have a MS Access frontend linked to a SQL server backend storing the tables. I've created some pass through queries within Access and established a connection string, which are all working perfectly. Now my problem is that I need to create more pass through queries which reference the existing pass throughs not tables. I get this error when referencing a pass through called "qryLWOS".

ODBC--call failed.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'qryLWOS'. (#208)

Any ideas??
 

Users who are viewing this thread

Back
Top Bottom