Front-end updates with DOS batch file

[cbirknh]

Hi Everyone,
I am running an SQL Server 2000 backend with MSAccess projects (*.adp) front-ends and am struggling to find an automated way to send out revisions to the front ends.

I have created a *.bat file which deletes the old version, inserts the new and opens the program. Unfortunately (as you might expect), this only works if the database is not open. Is there a way to have the .bat file close the database (if open) then run the other commands? By the way, here is the code:

@cls "c:\Program Files\Folder\FrontEnd.adp"
@mkdir "c:\Program Files\Folder"
@del /Q "c:\Program Files\Folder\FrontEnd.adp
@copy "\\Server\Folder\FrontEnd.adp" "c:\Program Files\Folder"
@start msaccess "c:\Program Files\Folder\FrontEnd.adp"

Thanks,
Chris