#Name? in Fields - Why does this happen?

B

Bonnie

Hi, using A02 on XP network. Use DB's in multiuser
environment. Seems like every 3-4 months, when running
append/update queries I get an odd 'Record is deleted'
message box. When I chg the query to a 'select', same
error. Sometimes, the select will actually show records
AND the 'Record is deleted' box, if I click Okay, all the
record fields will suddenly read #Name?. UGH!!! It changes
when I change the criteria and suspect I'm selecting or
not selecting the record in question, I just can't
identify it easily.

When I open the table and scroll, all looks fine, sort by
some fields okay, others give the same 'Record is deleted'
msgbox. Can't find an error visually.

Have always had to get a backup file, run a compare on the
2 tables to not lose the bit of work done since the night
before. (Only a very few folks have delete rights, could
it be they are deleting a record that someone else might
have open and that blows its mind? I could further
restrict when deletions are done.)

Can anyone shed some light on this for me? I'm not a
programmer but I love Access and everything it can do. I
regularly use the Newsgroups to learn more. Thanks in
advance for any help or advice you can provide.
 
L

Lynn Trapp

Bonnie,
Is your frontend database connected to an Access backend or to some other
kind of database? If it is an Access backend, then I suspect there is some
underlying corruption in the database. have you compacted the database
lately?
 
B

Bonnie

Yes, I apologize for not mentioning that. I do have a
backend/frontend situation. I did run a repair and compact
on the backend and it removed the 'bad' record. I will
compact it more often in the future.

Thank you VERY much for your response, it gave me the
final clue to (hopefully) keep this from happening again.
 
Top