I have an Access 97 database with a few Linked Tables to SQL tables. This works fine from Windows XP with Access 2002 and 2003. However, new Windows 7, 64-bit PCs, running either Access 2007 or 2010, cannot run a daily report that initially runs a macro and then loads the daily sales report data. Once the macro is run (by someone else) and the data is loaded, the Win7 PCs can then display the report and carry on. I have seen suggestions referring to the need to use the 32bit ODBC driver specifically for the ODBC connection and have tried that, but it still doesn't work from the 64bit Win7 PCs. I could convert the database to Access 2002 or 2003, or even 2007, if necessary I guess, if I save it as an .mdb format so the prior versions could still open it. I'm not convinced converting the database would resolve the issue, however. Any ideas or recommendations?
This is the error I get:
Macro Single Step error: 3151
Arguments: queryMakeTbl, Datasheet, Edit