I built an access database system which has been running my Son's business very well for 5 years. Yesterday, the system "froze" (his words) for a while and then he found that all the records had been deleted from a table containing text fields (containing notes about client conversations). This is the largest table in the system and contained 75,000 rows.
There is no code anywhere in the system which will deleted records from a table. I find it hard to belive that it would be a virus as it would need to be very specifically targetted.
Does anyone have any ideas on how these records got deleted? Are there any keystroke combinations that could acieve this if the user did something strange?
We have gone to backup but have lost a whole day's worth of notes and I am worried that if we don't know why this has happened then it could happen again.
Any thoughts would be greatly appreciated.
Thanks
There is no code anywhere in the system which will deleted records from a table. I find it hard to belive that it would be a virus as it would need to be very specifically targetted.
Does anyone have any ideas on how these records got deleted? Are there any keystroke combinations that could acieve this if the user did something strange?
We have gone to backup but have lost a whole day's worth of notes and I am worried that if we don't know why this has happened then it could happen again.
Any thoughts would be greatly appreciated.
Thanks