How to delete the #Deleted Record in the table?

D

Deasy

I have Table1 and Table2 and they are related each other 0ne to many. Every
one record in Table1 have many record of Table2.

I have one record in Table2 that shows #Deleted. My records shows 10
(include the #Deleted).

How to deleted that #Deleted Permanently?

Because it makes all Query that related to Table2 became error.

Please Help..........................................
 
T

TC

As far as I know, #Deleted only shows when the record is displayed on a
form, and then you delete that record /through code/, "behind the
scenes". That is, you do not let the normal Access processing delete
that record - you do it yourself, explicitly, through code, behind the
scenes. Access then displays #Deleted, to show the status of that
record.

#Deleted is never stored in the table - it's just a message to tell you
what has happened.

To fix this problem, you should requery that form; or preferably, /not/
delete records "behind the scenes"!

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
D

Deasy

I already compact the database. and it works. Does it safe for my database?
Why the other user that have no permission for delete, can delete the record?
And why I am the admin can't deleted that #Deleted record?

Thanx for your help....
:eek:)
 
T

Tony Toews

Deasy said:
I have Table1 and Table2 and they are related each other 0ne to many. Every
one record in Table1 have many record of Table2.

I have one record in Table2 that shows #Deleted. My records shows 10
(include the #Deleted).

How to deleted that #Deleted Permanently?

See the Damaged records within tables section in the To retrieve your
data from a Corrupt Microsoft Access MDB page at my website
http://www.granite.ab.ca/access/corruption/corruptrecords.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top