Windows 7 and Access 2007 ODBC Connection problem

  • Thread starter Thread starter Demariye Gissendanner
  • Start date Start date
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.

Is it a Windows 7 permissions thing????
 
Chris said:
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.

Is it a Windows 7 permissions thing????

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.
 
Back
Top