Error Message

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2007 - I have a locations table that is getting a #Deleted message on
a row. The #Deleted message is in every segment of the row. It will not let
you delete the message. It looks like it is deleted, but when you bring the
table back up, it is still there.

Does anybody know what the #Deleted is? I have never seen it before. Thanks!
 
It means you have deleted a record of data. I assume you are using a form to
enter data?
 
No, I have not deleted any data - and yes I am using a form. What has
happened is that one of the records has been changed. The form lists pallet
tags with their locations, among other things. The location of the pallet
changed in the warehouse, so the location on the tag was changed via the
form. We had done about 10 of these when one of them blew and gave this
message. The other tags were okay. I have deleted rows of informatin before
but have never seen this type of message. A compact and repair cleared it up
but I don't know how to prevent it from happening again.
 
Information somewhere was deleted for that message to appear.

If you are using combo boxes and you delete one of the options a "#deleted"
message will appear in the list and will do until it gets requeried or
updated.

Do you have multiple users?
 
Yes - there are multiple users but limited access to the actual tables. We
got a similar yet different error message today - Same location - but this
time it was #Error - and then we got a pop uo box that said this is not a
valid bookmark. The only way we could get out was through task manager.
Compact and repair fixed it too but I would like to find out what is causing
it. Thanks!
 
Back
Top