For our ASP based application, We need to take dump of msaccess DB everyday and users update info from application. if everyone is login/online and we want to take dump of access, Do we have to shut down the database to create the dump? Can we do it without shutting it down? if yes, do we miss some rows if users are online? How long it would take to do dump of 5 MB file, if we shut it down in the night when everyone is logoff/gone in system? Can we write a script which runs when everyone has logged out?

__________________
Rams

What do you mean by a dump of Access? Are you exporting each table to a different format (ex: Excel)? Could you simply be making a copy of the db file and emptying the tables in the users copy? As far as I know there is no generic way of "dumping" Access. You need to spell it all out for us.

-Phil-

dump means just copying the db file.

thanks