Problem with Access 2003 linking tables with SQL Server 2008 using ODBC

Posted by tyguy840 on Stack Overflow See other posts from Stack Overflow or by tyguy840
Published on 2010-03-29T17:35:53Z Indexed on 2010/03/29 17:43 UTC
Read the original article Hit count: 424

I am trying to link an Access 2003 DB to tables in a SQL Server 2008 database using ODBC. When I try to link to tables that have Primary Key established I get the following error message.

" 'Pk_dbo.Batch_Claims' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not to long. "

Pk_dbo.Batch_Claims is the key value I see when looking at the table through SSMS. I have used Access for awhile but am somewhat new to SQL Server and connections using ODBC. Any help would be appreciated.

Thanks

© Stack Overflow or respective owner

Related posts about access

Related posts about ms-access-2003