Hard Delete

H

H. Snyder

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
 
D

Dirk Goldgar

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
Click to expand...

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?
 
H

Howard Snyder

-----Original Message-----
Click to expand...
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
Click to expand...
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?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
Click to expand...

1. Yes, drop down commands = regular menu commands in my
vernacular.
Read you comments and agree that something more
complicated is going on. Sure its simple but, how do you
get to the Form's property sheet? Seems like I need to
select a field, label or section before I can right click
to properties.
 
Top