I have developed a MS Access database, went corrupted and could not even repair using ACCESS own "Compact and Repair" or JetUtil.
That said, I ended up restoring it from the backup device and all is good.
But the reason I am posting this question is:
(1) When users are using the database on a local network, it is fine.
But this has happened before when users connected to the database via VPN tunnel.
(2) The database file size was 6.7MB, but this morning the size was 412K and there was .ldb file as well.
My question is how the database file size can change so drastically, let alone getting corrupted?