I have a form bound to a table. The table has 73,000 records and has been working mostly well for years. Lately (after a recent switch of fileservers) when someone adds a new record it will either take the first record in the table and put that info into the new record, or it will take the info from the previous record and put that in the new record. In both cases the record that got its data stolen vanishes into the bit graveyard. Also, every once in a while the Primary Key will get deleted and that causes a whole different set of problems but I can just put the PK back and everything goes back to normal (at least with that little set of issues). I can not repeat the problem. There are two users using the same table at the same time checking in new samples.
Records Being Moved and Deleted and Primary Key Being Deleted
- Thread starter geraldcor
- Start date
FE/BE all users have their own copy. Regular backups are being made. In fact, I made a little script that kicks everyone off the database during backups to see if that would help the situation. We are getting less corrupt records but this error prevails. I am planning to move to a MySQL BE soon so now may be better than later.
Any Other thoughts out there?
Any Other thoughts out there?
