#ERROR and #DELETED appearing in tables (1 Viewer)

[homer2002]

Hi

I have a muli-user database that's been creating the odd strange record for me

two records that have been created have all the fields data as

#ERROR or
#DELETED

no matter what I do with these records I can't get rid of them or find out where they came from.

Can any help me just delete these out of the table?

Would be extreemly helpful as they are now getting on my nerves

Cheers Homer

 

[Len Boorman]

They are not easy to get rid of. The only way I have found is to

FIRST take a backup and then another
then
1) Create a new table with same design as existing table
2) Append all records to this new table except the ones in error
3) Delete original table (careful)
4) Rename new table and remake all relationship links

More importantly establish how they occurred. I suugest that you do not have a record locking strategy in place. Generally this sort of problem occurs when two users try to edit the same record

Len

 

[homer2002]

Nice, one.

I was hoping not to have to make the table again, and cheers for the insight into record locking.

I guess i'll have to go over my code ensure i'm locking everything right.

Cheers again. Homer

 

[Len Boorman]

I use separate forms for Viewing, Editing or Adding data

Viewing forms are displayed in Read Only Mode so no worries about locking

Edit forms lock edited record

Add forms simply add.

I do not mix capabilities on same form (generally)

Len