Log et al – Peter Curd

An irreverent peek into the inner rumblings of Peter Curd

Apr

22

Access 97: The database engine can’t find Error

By pcurd

When linking to a SQL Server table in Access 97 today I came across this weird error:
“The database engine can’t find TableName. Make sure it is a valid parameter or alias name, that it doesn’t include invalid characters or punctuation, and that the name isn’t too long.”

As the table name was reasonably small, and I had longer table names already linked, I became suspicious.

The problem was indexes, if the total length of the table name plus the length of the name of the longest index is longer than 64 characters, you get that error. Making the index name smaller solved the problem.

4 Responses so far

Good stuff. Wish I had found it a couplel of days ago.

Good Job. Thanks!

Wow, that’s an obscure cause. And, it’s exactly the answer to my problem. Thank you.

I’m glad this has been useful!

Leave a comment