I developed an Access 2007 application on my computer (XP Pro-Access 2007) that uses a ODBC client to connect to linked tables. After completion of testing I moved it to a virtual Production box with XP and Access 2007. I retested to make sure all is ok and all of my queries that use the ODBC link fail with...
ODBC Call Fails.


[TOD][ODBC][GENESIS]Worm: Cannot open ‘CP_ORDLIN’, no privilege to this file or directory (#-55).
I have developed numerous other apps without problem except they were all in Access 2003. The strange thing is that on the new production box, even though all of the queries I initially wrote fail, I can write a new query against an ODBC linked table and it works just fine. It's as if something from my computer is embedded in the accdb that is causing a 'rights' issue with ODBC. It doesn't matter how I log on to the production box (AD Administrator or my profile).
Any help is much appreciated.