ACCESS FEED: RE: [MS_AccessPros] #deleted in a field value

Kamis, 25 April 2013

RE: [MS_AccessPros] #deleted in a field value

Sometimes when it happens , an index is removed, then you need to delete
records showing deleted# mark , run a compact database , recreate the index
and then create a blank database and import all objects from fixed
database.

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of RobertoARV
Sent: Thursday, April 25, 2013 11:28 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] #deleted in a field value

I have seen this for years with this database , often happens when you
migrate same database to another upper version, you need to install all the
Microsoft jet service patches. it also occurs when you edit same record in 2
computers , it shows deleted in other computer but it get fix when you run a
requery in form or simply close form and open it again. it happens too when
a network disconnect occurs when you are editing a record.

From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Bill Mosca
Sent: Thursday, April 25, 2013 9:39 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: RE: [MS_AccessPros] #deleted in a field value

Ray

The most likely cause is a corrupted index. It might have been saved if you
imported it into a blank database (which sometimes fixes bad indices). I'm
glad
there was a backup, though. That was good thinking on your friend's side.

Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP

<https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-642707308
81E>
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-6427073088
1E

My Nothing-to-do-with Access blog

<http://wrmosca.wordpress.com> http://wrmosca.wordpress.com

From: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
[mailto:MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com> ] On Behalf Of Ray
Sent: Thursday, April 25, 2013 5:39 AM
To: MS_Access_Professionals@yahoogroups.com
<mailto:MS_Access_Professionals%40yahoogroups.com>
<mailto:MS_Access_Professionals%40yahoogroups.com>
Subject: [MS_AccessPros] #deleted in a field value

Can you shed some light on this mystery? A friend has an Access 2003 db and
one
table has some rows with #deleted in each field rather than the data that
used
to be there. I suspect that they have used the "delete record" button from
the
toolbar to delete a few rows (I know, not a good idea) and that something
went
wrong. When a query runs on this table it returns an error saying that a
record
has been deleted and then stops dead.

We recovered the database from a backup and life has moved on. However, I've
never seen this before, have you?

Many thanks
Ray

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]