Delete Data in SQL using Delete Query in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

All,

I have a simple query that deletes data in a table and it is used for
updating purposes.

I am converting my .MDB's into SQL and it has been going Great until I
received this error that will not let me Delete Row that are linked to SQL
via a ODBC.

Am I Doing something wrong? if so can anyone please guide me?!?!?!

a million thanks!
 
Duane, Thanks for the response.

No there are no Primary Keys associated to the Linked table. In fact, that
table is just a source for all of the fields that get updated. The reason
that I created this table was that I took much longer to update from a Linked
TEXT File. by importing the information, it took less time to update my Data.

Like I said it a a Simple Query:

DELETE OPSEC_VIEW.*
FROM OPSEC_VIEW;

But I get error 3086 "Could not delete from spcified tables. I have my SQL
database open with no restrictions and it is definitly not read only.

Thanks,
 
I asked about the primary key field because you must have one in the linked
table in order to delete or even edit the table. Add one and refresh your
link.
 
Back
Top