H. Snyder said:
Records that have been deleted using drop down commands in
the front end are still in the main table. Queries are
run off the main table. How can record deletions made in
the front end be made permanent so the queries relfect the
edited data? Please keep it simple - I'm a user not a
programmer. Thanks all
By "drop down commands", do you mean regular menu commands like
Edit->Delete Record? If so, the only way the deleted record could
remain in the main table is if the form or datasheet you are deleting
from is not actually based on the main table at all. Possibly it's
based on a local table, not the main table in the back-end, or possibly
it's based on a query that is joining another table to the main table
and is deleting from that other table. Access does perform "hard
deletes", so if your records aren't being deleted from the back-end,
there's something more complicated going on.
Are you deleting from a form or from a table datasheet (opened from the
Tables tab of the database window)? If you're deleting from a form, can
you open that form in Design View, open the form's property sheet, and
report the value of the Record Source property from the Data tab of the
property sheet? Conversely, if you're opening a table datasheet from
the database window, does that table indicate that it is a linked table?
