I have a Access 2010 frontend connected to a SQL Server 2005 Express backend.
I was able to use Access 2010 to migrate my tables using ODBC to the SQL Server.
I can open my Access 2010 frontend. I am able to open tables, run queries, and open some forms and see data.
However, when I open one form, I get a ODBC failed message.
This does not make sense to me that it would connect and show me data from all tables but not show me information on this one form.