Exporting Tables to another database automatically

[luvthisboard!]

copy and paste mdb file automatically !

HI,

Have looked through threads but can't seem to find similar question.

I want to copy a full database .mdb file from one drive to another copy and paste over an existing file, simple ! but can I automate that from within another database ?. reason. The database I want to copy is the BE of a split database and remote users keep a copy of it on their local pc's which their FE links to. whenever they dial in to the server I want them to copy over the latest BE, my worry is they may do it the opposite way ! i.e put their copy of the BE tables on to the server ! so If it was possible to automate it, from within their FE, it would eliminate the room for error !. have tried all of the transfer database, import, copy object etc.. macro commands but nothing working

any ideas ?

 

[The_Doc_Man]

The problem you MIGHT have is that if the object being copied is currently open, it might be locked against exactly what you wanted to do.

Now, if the .MDB file WAS available and not locked, you could use VBA to do a

FileCopy source-file-spec destination-file-spec

where both specs need to include paths. So you MIGHT have to manipulate file paths a little bit beforehand.