I've posted this question in a MS Access forum but nobody was able to figure out what the issue is.
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.
- 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)
I tried changing the SQL table name to a single word (like "TEST") but it didn't make any difference.
Anyone came across a similar issue?
Any suggestion is appreciated.
View Complete Post