Problem Deleting Records

[Mugs321]

Hey all,
I've seen many posts across the Net regarding this issue, though none have been of any help.

I'm trying to delete some records using the following simple query (the tables are linked to an MSSQL database):

DELETE FROM Prod_Results WHERE AttemptID=51362

It keeps returning a "Could not delete from specified tables" error. I've tried encasing the 51362 in quotes and I've also tried adding a '*' between DELETE and FROM.

The query works perfectly fine if it's run on the server. Any ideas?

 

[Mugs321]

Nevermind... so apparently if you do not specify a primary key when linking, you get a Read-Only table... and that was the problem.

 

[PHV]

the tables are linked to an MSSQL database
Does the DSN's user have delete permission on the underlaying table ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Mugs321]

The user has both db_datareader and db_datawriter permissions.