Sure this is a very common problem people have.
I'm using Access 2003 with front-end forms, 5 people log into the database most of the time and access the same table from the front-end forms. Now and again a record becomes corrupt and just shows "#error" or "#Delete" in all the fields and it can't be deleted. I first thought this could of been just a network error but it's happening to often. I then changed the layout of the table as it had a "memo" field which I have now taken out and put in it's own table and this table now doesnt' corrupt.
So I can only think it's down to the multi-users hammering the same table at the same time. Is there anything I can do to stop this, if it's to change the design of how everything works or anything else I can do to the database.
Thanks