Can access finish a script after close

[halfbodyguy]

I am trying to make a file update sort of thing for when I make changes
to the user-side MDB
I have it checking byte size vs the master copy on a server. My desire
is to have it copy it, close the one its in, and rename the copy to be
the original. Obviously the problem is that the renaming cant be done
after access is closed... Is there any way anyone can think to automate
this process?

 

[Guest]

Would it be sufficient to overwrite the client copy when starting an mdb
instead of when closing it? If so, try this:
http://www.granite.ab.ca/access/autofe.htm

We use it to deploy changes to split databases and it works very well.

Barry

 

[Warren]

I'd use a batch file... Have your users run a .bat not a .mdb or .mde


eg.
-------------------------------------------------------------------------------------------
@echo off

if not exist "h:\DatabaseFolder" mkdir "h:\DatabaseFolder"
xcopy /y /q "G:\MasterDBFolder\*.*" "h:\DatabaseFolder\*.*"
start /max D:\Apps\Micros~1\Office\msaccess.exe
"h:\DatabaseFolder\MyDb.mde"
exit

 

[Guest]

This won't work if the file already exists but is a different version of the
server copy, which is what he's looking for.

Barry