i have a sql server back-end and a ms access 2007 front-end. i have a View on this back-end that has sales order data in it. when running a query and putting a certain sales order number in the where clause (say sales order 12345) it returns 183 records.
i have linked this View to my front-end. i have built a query in Access that is the same as the query that i ran on the back-end. it only pulls 22 records.
i know this View when run is cumbersome and takes a while to run. on the back-end in sql server management studio i have no timeout or any issues when opening the View. when double clicking on the linked View on my front-end i get the odbc timeout error. so the front-end query i have the timeout property set to 0 (so it won't timeout).
just curious why all records don't get pulled? has anyone had an issue like this before. i mean every other linked table or view operates just fine and the queries match record totals from what i pull on the back-end to what is pulled on the front-end. any help would be appreciated. thanks.