Delete query causing error 3086

[vba317]

I have written a delete query in access 2003 that is giving me a 3086 error. I don't have tables open. I also am only using one table to delete from. So I don't know what else I can do. The table is a linked table.
The error spot is highlighted in green. Any help is appreciated.
Tom

strSQL = "DELETE " & _
         "FROM dbo_rpt_dat_CSDetail cs " & _
          "WHERE cs.uci = 'JVB' AND cs.rptpd > 372 AND cs.trantype = 1 AND cs.modalid = 6;"
 [GREEN]  CurrentDb.Execute strSQL [/GREEN]

 

[dhookom]

Can you edit records in the table?

Does the table have a primary key? If so, does Access know which field or fields are the primary key?

Duane
Hook'D on Access
MS Access MVP

 

[vba317]

No, the table does not have a primary key.

Tom

 

[dhookom]

If this is a linked table from SQL Server and you don't have a primary key, you can't edit or delete records.

alternative might be to create a pass-through query to delete the records. However, every table/record deserves a unique/primary key.

Duane
Hook'D on Access
MS Access MVP