moving access databases that links to a backend SQL Database from access 2007 to access 2010(32 BIT) also moving from windows XP maching to a new system with Windows 7 Pro.
I need to relink the tables but Access 2010 does not show the System DSN options.
I used the System DSN option to link to the SQL tables in the Access 2007 system
this access database is used by other members in our dept that are still using Access 2007.
how can i get Access 2010 to use or see the System DSN.
I have setup a SYSTEM DSN via the ODBC Manager to match the System DSN on my old system.