Copying ms-access databases

I think access databases should not be copied while a connection to them is open (.ldb locking file exists) as the copy file can be corrupt. However will the copy file be corrupt only if a edit/add/delete is carried out while the file is being copied. I'm thinking of situations where a connection to the database is left open all the while the client application is running. Specifically I'm wondering about ov开发者_运维技巧er-night backups where a user leaves on their machine overnight.

You might like to consider Automatically Logging-Out Idle Users

I've never experienced a problem when copying a database whilst in use. This doesn't mean it's a good idea of course....

You may want to look at some kind of mechanism to automatically kick users out of the database after n hour or at a certain time of day.

That should be fine.

You should be able to copy the file without any problems.

I just tested this, and if the user was in the middel of an update to a record, the new copy only has the original value of the row, not the values being edited.