K
Kirk P.
I just had a database file delete itself and replaced with a file named db1.
Unfortunately, when I try and open the db1 file, I get "unrecognizable
database format" error.
I was accessing the database (Access 2003) on a corporate network from home
via a broadband VPN connection, compact on close is turned on, and the
problem happened when exiting the database. I suspect a problem with
"compact on close", so I'm pondering whether I should turn this off and train
the users to periodically compact on their own.
I know I should split the db into FE/BE, which I certainly will do - any
other advice to prevent this in the future?
Unfortunately, when I try and open the db1 file, I get "unrecognizable
database format" error.
I was accessing the database (Access 2003) on a corporate network from home
via a broadband VPN connection, compact on close is turned on, and the
problem happened when exiting the database. I suspect a problem with
"compact on close", so I'm pondering whether I should turn this off and train
the users to periodically compact on their own.
I know I should split the db into FE/BE, which I certainly will do - any
other advice to prevent this in the future?