Hi there,
I've, today, created my first pass-through query (wahooooo!) which links my Access 2007 db to a query in SQL Server.
Is there a way that I can refresh the SQL Server query from Access?
For example, when I "refreshall" from Access, the pass-through always remains at the same number of records. Because I have no visible access to SQL Server, I was advised that the query in SQL Server needs to be refreshed each time and that I can do this via Access, but not sure how to.
My apologies if I am using incorrect terminology here, but I hope you get a gist of what I am asking.
Many thanks.
I've, today, created my first pass-through query (wahooooo!) which links my Access 2007 db to a query in SQL Server.
Is there a way that I can refresh the SQL Server query from Access?
For example, when I "refreshall" from Access, the pass-through always remains at the same number of records. Because I have no visible access to SQL Server, I was advised that the query in SQL Server needs to be refreshed each time and that I can do this via Access, but not sure how to.
My apologies if I am using incorrect terminology here, but I hope you get a gist of what I am asking.
Many thanks.