Link to SQL Table in Access 2003

See more:

MS-Access

ODBC

SQL-Server-2008R2

I have an SQL 2008 database containing a table with close to 1 million records. I'm trying to connect with an Access 2003 database via ODBC. I create the ODBC connection successfully, and I use that connection to link my tables. When I get to the end of the wizard, I can see the list of tables. I choose that table and click 'OK', but as soon as I do, Access tells me that it 'cannot find the table'. I tested the same ODBC connection with Excel 2010 and it worked. All rows were imported. What should I be looking for?