423,311 Members | 1,224 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 423,311 IT Pros & Developers. It's quick & easy.

Error 3167 Record is Deleted **

P: n/a
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!
Feb 14 '08 #1
Share this Question
Share on Google+
2 Replies


P: n/a
da******@verizon.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
Feb 14 '08 #2

P: n/a
da******@verizon.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/corr...uptrecords.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/
Feb 14 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.