can't delete records

  • Thread starter Thread starter a
  • Start date Start date
A

a

I have query and three table join to each other the join is working good but
I have one problem:

---------

When I delete any records and reopen the query again I find the records not
deleted

What should I do?

Or Whats the wrong?
 
When you "delete ... records" are you warned? If not, the SetWarnings has
been turned off, and you are not able to see when Access is having problems.

Can you delete a single record in a single table?

If you have three tables joined, from which table is Access supposed to
delete which record?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
I have query and three table join to each other the join is working good but
I have one problem:

---------

When I delete any records and reopen the query again I find the records not
deleted

What should I do?

Or Whats the wrong?
Click to expand...

Your joins are probably done incorrectly. Deleting from a three-table join can
be tricky and requires care. Could you post the SQL of the query, and indicate
what it is that you want deleted?

John W. Vinson [MVP]
 
Back
Top