Query Type changes by itself

[RayMilhon]

I have 14 Linked tables to SQL Server the Queries work perfectly. The issue is when I close the Database the next time I open it the Select Queries are now Pass-Through Queries. Why does Access automatically change the query type? The problem is the queries are designed to be run automatically and as Pass-Thru queries they fail everytime.

[Bulzie]

They should not fail, pass thru runs the query on the SQL side so is much quicker then Access queries most times. So you can run them manually and they run ok, but when you run them all in code or macro they fail? Do they give an error message when they fail?

[RayMilhon]

Nope but I was able to work around it. Have a local SQL Server that we use here. Linked to the Production Server at Corporate from there and created 2 Views from the Queries I ran in Access and I can now automate the reports to send out.