Error 3167 Record is Deleted **

[david720@verizon.net]

Error 3167 Record is deleted
And
Sometimes the main entry form displays a record in the form where all
fields are "#Delete"

Why do we get this error sometimes (about 2 times a week)?
It happens from different users and on different workstations.
Also in this application no records are ever deleted and would be
difficult for a user to delete a record

Environment:
Access 2003 (converted from Access 97)
XP workstations, jet 4 with SP 2
Split into Front and Back end, both mdb's
Large databases, FE, 39m, BE, 140m
The main table has a large record length but the system functioned
find in ver 97

Thanks for any responses!

[Bob Alston]

Re: Error 3167 Record is Deleted **

david720@verizo n.net wrote:

Error 3167 Record is deleted
And
Sometimes the main entry form displays a record in the form where all
fields are "#Delete"
>
Why do we get this error sometimes (about 2 times a week)?
It happens from different users and on different workstations.
Also in this application no records are ever deleted and would be
difficult for a user to delete a record
>
Environment:
Access 2003 (converted from Access 97)
XP workstations, jet 4 with SP 2
Split into Front and Back end, both mdb's
Large databases, FE, 39m, BE, 140m
The main table has a large record length but the system functioned
find in ver 97
>
Thanks for any responses!

The form characteristics you describe seems to be that a record
initially displayed has been deleted. I seem to recall having seen that
previously.

I personally have seen error 3167 due to corruption in a replicated
database. Try to import all the existing back end tables into a new
database. If it works with out error, you do not have corruption, at
least the same kind of thing I experienced.

As I recall, the speculation about my 3167 error was that the external
pointer to a memo field was corrupt. maybe this will help point you in
the right direction.

HTH

Bob

[Tony Toews [MVP]]

Re: Error 3167 Record is Deleted **

david720@verizo n.net wrote:

>Error 3167 Record is deleted

You get that as a message? Then, as Bob states, that's a sign of corruption. You
might only have a record, or as Bab points out, a corrupt memo field.

See the Locating damage via code section at the following page.
"A method to locate minor corruption, especially in memo fields is to write some code
which loops through the records looking for an error when accessing the memo
field(s)."

http://www.granite.ab.ca/access/corruption/corruptrecords.htm

>XP workstations, jet 4 with SP 2

SP 2? Ah, you mean Win XP SP2.

Jet 4.0 (msjet40.dll) version number should be 4.0.8618.0 as per Microsoft Security
Bulletin MS04-014.

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

Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/