I have an old excel report application which still works in windows XP and Excel 2003. But after I upgraded my pc to windows 7 64 bit and Office 2007, the report throws error below. Actually I tested on both windows 7 32bit and 64bit, it's the same error. So, I guess it's related to windows xp and 7, not 32bit or 64bit;
"There was a problem connecting to the database. Please try running the report again. If the problem persists, contact your system administrator. Login failed for user 'reporter'" I'm not sure this uses ODBC, either. The server is SQL 2000 Express
I'm not good at excel, The excel report file shows as xlt and when I open the report from office 2007, then go to macro, it shows a bunch of codes. Where do I start to solve the connection problem, in administrative tools/odbc or modifying the macro?