Error linking MS Access to SQL Express

bimmer5

Registered User.
Local time
Today, 00:59
Joined
Apr 22, 2008
Messages
67
I am getting the following error when I try to link MS Access 2010 to a SQL Server Express 2008R2 table:
'idx_table name' is not a valid name. make sure it does not include invalid characters or punctuation and that is not too long.

Details:
- the table name is: italpasta-etp.etp.timehistory
- the connection: 64bit ODBC (test successful)
- I get the same error if I try to import the table
- both MS Access and SQL Server Express are new, 64bit installations (I don't know if that matters)

Anyone came across a similar issue?
Any suggestion is appreciated.
Thank you.
Peter
 
As suggested, I tried renaming the table but I still get the same error message.
 

Users who are viewing this thread

Back
Top Bottom