Hi,
In August 2002 I built an Access database. From that point on, only my colleague has entered data into this database. If any changes to the structure were to be made, I was asked to do them. The database had functioned without any problems till last week when I noticed two very strange things.
The size of the database had suddenly shrunk from 3600kB to a mere 900kB !!!! In addition, every time the database was opened, the “create dates” of all the forms and reports got re-created: allof them showed that they were created on the same day at the same time. Surprisingly, the database still functioned that way and we did not seem to have lost any data.
Can anyone PLEASE tell me what the possible purpose of this shrinkage and change of create dates could be? Since I do not assume this is very safe for the database to keep happening, I would also appreciate any advice on how to prevent this from happening in the future.
Thank you so much!