I just created a Windows 7 PC (Enterprise Eddition) and have Office 2007 Pro.
Both are fully patched. I have an access application that works on an XP PC
but fails on the Windows 7 PC. Both PCs have an ODBC connection and both
past the Connection Test.
However, when I opend the application on the Windows 7 PC it fails with an:
ODBC - connection to 'Calltrack_Access' failed.
error. Not sure what would cause this. I've given the file location full
access rights in Access including subfolders.
Did you try decompiling your ACCDB or MDB database file after copying from
WinXP to Windows 7?
--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)
I just created a Windows 7 PC (Enterprise Eddition) and have Office 2007
Pro.
Both are fully patched. I have an access application that works on an XP
PC
but fails on the Windows 7 PC. Both PCs have an ODBC connection and both
past the Connection Test.
However, when I opend the application on the Windows 7 PC it fails with
an:
ODBC - connection to 'Calltrack_Access' failed.
error. Not sure what would cause this. I've given the file location full
access rights in Access including subfolders.
If you're running Win 7 64-bit did you use the 32-bit ODBC configuration?
When you say you've given the file location full access rights, that needs
to be done twice- once for Windows permissions on the file folder containing
the mdb (which needs Modify rights) and once in the Access Trust Center to
enable code to run from that folder.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
