hi guys,
We have a pass through query (to MS SQL2005) which does 'select * from aView'
- I know you should specify the fields....
It works fine until you change the columns that are returned by the view and then is broken - it either gives a message about binding or returns the old column headings and no data.
I have also had a similar problem where the pass thru query is calling a stored procedure and the SP dataset has been modified.
I guess that somewhere in the access database, it stores the results that it is expecting back from the query. Is there any way to get this to refresh itself.
We are using Access 2003.
We have a pass through query (to MS SQL2005) which does 'select * from aView'
- I know you should specify the fields....
It works fine until you change the columns that are returned by the view and then is broken - it either gives a message about binding or returns the old column headings and no data.
I have also had a similar problem where the pass thru query is calling a stored procedure and the SP dataset has been modified.
I guess that somewhere in the access database, it stores the results that it is expecting back from the query. Is there any way to get this to refresh itself.
We are using Access 2003.
