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

Try naming the table:

italpasta-etp.etp.timehistory to tblTest and see what happens...

As suggested, I tried renaming the table but I still get the same error message.