Windows 7 and Access 2007 ODBC Connection problem

Windows 7 and Access 2007 ODBC Connection problem

Post by Demariye G » Tue, 26 Jan 2010 15:34:07


that sounds great
 
 
 

Windows 7 and Access 2007 ODBC Connection problem

Post by Q2hyaX » Wed, 27 Jan 2010 08:06:03

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????

 
 
 

Windows 7 and Access 2007 ODBC Connection problem

Post by Sylvain La » Wed, 27 Jan 2010 09:08:28

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://www.yqcomputer.com/
Independent consultant and remote programming for Access and SQL-Server
(French)
 
 
 

Windows 7 and Access 2007 ODBC Connection problem

Post by Paul Shapi » Wed, 27 Jan 2010 12:21:30


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.