Hi folks, I apologize in advance if this is the wrong forum for this but a strange issue popped up that I was wondering if anyone knows something about. I have an Access 2010 db that I'm using as a front end to a SQL server back end, there are several linked tables and querydefs in the access db. Additionally I have an Excel 2010 workbook with a VBA module that is calling one of the Access DB's querydef's via DAO. Before tonight I was able to run a Macro which calls a querydef and the recordset is then copied into Sheet1. This worked splendidly well until I upgraded the back end tonight from Express 2008 R2 to full SQL Server 2008 R2. What's interesting is that it hasn't stopped working altogether, instead it returns one or at most two records when the recordset is larger. If I run the query from access it returns all of the records. I'm baffled why an upgrade from SQL Express to Full would do this. Any ideas?