Cannot delete records

[muppetmad]

I have a query of records that are not related to records is the secondary table. I want to delete these records but when I select the records and click delete I get the confirmation to delete answer to delete them and all the records disappear. When I run the query again, all the records are still there. Does anyone know what is happening? This is an access front end that connects to a SQL server database.

 

[boblarson]

When you linked to the SQL tables

1. the tables on SQL server MUST have a PRIMARY KEY defined.
2. when you link to the SQL server tables, you must tell Access which is the primary key (if it gives you a prompt to ask for that info).

Otherwise your data is ALL read-only.