#Deleted in feilds of record in Table Access 2003

[Guest]

Periodically we find a record in a table that has #Deleted in all feilds of
the record. It can not be deleted. The database must be compacted and
repaired and then the record can be deleted. This is usually discovered when
a user open a form that uses a query linked to that table and they receive
"Record is deleted" window. The record is not deleted by any users. Seems
to be a false state.

Last occurance - someone indicated they were in the record put in this
state. They used the back space to clear information in the record. That
was only known change to the record.

Looking for a possible root cause.

 

[Allen Browne]

The symptom indicates a corruption is taking place.

The most common cause of corruption is an interrupted write, i.e. Access is
attempting to save a change, but only partial information is written. There
can be many causes, such as a faulty network card (if data is coming over
the network), faulty computer, interrupted power, etc, etc.

For suggestions on what to do, see:
Preventing Corruption
at:
http://allenbrowne.com/ser-25.html
It's a fairly extensive list to work through: don't skip over items.

 

[Todos Menos [MSFT]]

you know... if you had an ounce of logic, you would move to SQL Server

MDb is for cripples and retards

 

[Tony Toews [MVP]]

you know... if you had an ounce of logic, you would move to SQL Server

MDb is for cripples and retards

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

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

 

[SusanV]

Phht! Doesn't he have anything better to do? This harassment has gone on for
years...

SusanV

"T o d o s M e n o s [ M S F T ]" <t o d o s_ m e no s _ m s f
(e-mail address removed)>
wrote:

you know... if you had an ounce of logic, you would move to SQL Server

MDb is for cripples and retards

Note that this person is really A a r o n K e m p f and that he is not
an employee
of Microsoft.

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

 

[Todos Menos [MSFT]]

if you had an ounce of logic, you would move to SQL Server

MDb is for cripples and retards

I mean.. just because Michael Kaplan is too retarded to learn ADP;
that doesn't mean YOU need to be

Phht! Doesn't he have anything better to do? This harassment has gone on for
years...

SusanV

"T o d o s M e n o s [ M S F T ]" <t o d o s_ m e no s _ m s f
(e-mail address removed)>
wrote:

you know... if you had an ounce of logic, you would move to SQL Server
MDb is for cripples and retards

Note that this person is really A a r o n K e m p f and that he is not
an employee
of Microsoft.

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