How to delete the #Deleted Record in the table?

[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..........................................

 

[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

 

[Alex Dybenko]

Hi,
try to compact your database, normaly - you can see #Deleted only when other
user deleted this record

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[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....
)

 

[TC]

Oops! I forgot the other /user/ doing that. :-(

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

 

[Tony Toews]

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