I have build several Access 200X databases for several clients with a SQL Server 200X backend. With clients that have Windows 7 X 64 I can connect to the ODBC connection using the Administrative tools, but when I go into Access 2010 I can not open the database. It works fine with Access 2007 but 2010 is failing.
Has anyone run into this and is there a solution?