Hello,
Please help! I originally wrote a database in Access 2003 that links to tables through an ODBC connection. Our company recently upgraded everyone's computers to Windows 2007 with Office 2007. I converted the database and it seemed to work flawlessly on my computer. However, others are really struggling with the performance of this database (which I just email out to folks when there are changes and they save it to their desktop). I've checked the basic functions of linking to an ODBC database and running a simple query. It works great...even on those computers that struggle to run my database. I've broken down the first Macro step by step and notice that it stops on the first make-table query. So, why does mine work well, but there is no rhyme or reason for why other folks' doesn't work. CONFUSED!!
Please help! I originally wrote a database in Access 2003 that links to tables through an ODBC connection. Our company recently upgraded everyone's computers to Windows 2007 with Office 2007. I converted the database and it seemed to work flawlessly on my computer. However, others are really struggling with the performance of this database (which I just email out to folks when there are changes and they save it to their desktop). I've checked the basic functions of linking to an ODBC database and running a simple query. It works great...even on those computers that struggle to run my database. I've broken down the first Macro step by step and notice that it stops on the first make-table query. So, why does mine work well, but there is no rhyme or reason for why other folks' doesn't work. CONFUSED!!
