Quote Originally Posted by VictorN View Post
Did you get this error while using exactly this queryor, perhaps, there were some "special" words that may be not allowed by Access 2007 or its drivers?
Nothing special "SELECT * FROM CLINETS".
As I said, I exported the Access data to MS SQL Sever, I changed the connection string and this query runs fine. So, I continue to conclude that is a MS Acccess issue.
I think the problem is the driver and the wonderful setting in Access 2007 which I meet every time I open a database: Security Warning Certain content in the database HAS Been disabled. For example, I must enable it to see a relationship between tables visually.