Copy Front End Dbase to Local Workstation


D

Dave C

I have a batch file that:

1 - Checks for the existence of a defined folder on the local workstation
2 - Creates the folder of required
3 - Copies the front end database from a shared folder on the network
4 - Opens the front end database on the local workstation

My problem/question is:
The batch file runs minimised but the window remains open until either 1)
the database is closed or 2) it is closed manually.

Is there a way that the command window can be closed once the database opens
as its code has been executed and I'd like to close the window rather than it
hanging around.

Any suggestions would be most appreciated.

Thanks ... Dave
 
Ad

Advertisements

D

Dave C

No need to answer this question as I've resolved the matter. If it helps
anyone the following works just great:

Sample Code

Set WshShell = CreateObject("WScript.Shell")
WshShell.Run chr(34) & "C:\Batch Files\syncfiles.bat" & Chr(34), 0
Set WshShell = Nothing

Copy the lines above to Notepad and save the file with .VBS extension. Edit
the .BAT file name and path accordingly, and save the file. Double-click the
..VBS file to run it.

Regards .... Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top