Salesforce Linked Tables in Access

[CypressHCC]

I am getting a -7711 error, the linked tables have data in them, this is happening when I try to run a query off of the linked tables.

I also tried to do a make table from the linked table and received the same error.

Any help is appreciated.

-T

 

[Micron]

Is this the "reserved error" message? Then the error message is probably too long for Access. Can't help much with that other than to suggest it's where you might want to start searching if no one here has the explicit answer. You might also want to attempt a simplified version of the query (a few tries with only one field, each try with a different field if the first few fail). If still a problem, it's probably not the query itself, but a connection problem - unless your query is an Access query using other sql syntax that Access doesn't like.