Quick question about deleting records

[pinecrest515]

Quick question:



I was having problems earliers with delete statements on Access queries. In effort to debug earlier problems, I started with a very simple query:

DELETE *
FROM table1 where [Last_Name] = 'Smith';

I got records "deleted" from table 1, but NOT physically. The "deleted" records were instead marked as "#deleted" for each column entry. Is there a way to make the deleted records disappear on table1?

[Rixxe]

DELETE FROM table_name
WHERE some_column=some_value

http://www.w3schools.com/Sql/sql_delete.asp

[weekend00]

close the table1 and open it again. the records will be gone.

[pinecrest515]

Thanks! Appreciate it!