Problem running delete query on remote server

[John]

Hi

I am running below query from within access

DELETE [My Table].*
FROM [ODBC;Driver=SQL
Server;SERVER=mysqlserver.net;DATABASE=mydatabase;UID=myusername;PWD=mypassword].[My
Table]
WHERE [My Table].ID = 3

I am getting a 'Could not delete from the specified tables' error. The
Insert and Select queries on the remote server work fine from within Access.
Also as I can delete the records manually form the remote server I presume
there are no permissions issues. What is the problem and how can I fix it?

Thanks

Regards

 

[John]

The error message I get is 'In order to evaluate an indexed property, the
property must be qualified and the arguments must be explicitly supplied by
the user.'

How can I fix it?

Thanks

Regards