Startup Batchfile

[DougAtAvalon]

I do I do an automatic update on a front end database
I heard I can use a batchfile. What is it, where do I put it on an NT computer, etc.

*and/or*

I have a Access DB that will copy the latest front end. Can I make this start up with Windows NT?


Let's say on each workstation there is:
c:\Directory\FrontEndFile.mdb

The Updated version is :
\\Computer\Directory\UpdatedFrontEndFile.mdb

 

[THoey]

You could have a batch file on the PC that would look in a particular directory for the existance of a UpdatedFrontEndFile.mdb on a network share. If it exists, copy it to your PC:

if exist "\\server\Updates\UpdatesFrontEndFile.mdb" goto FileFound
goto FileNotFound
:FileFound
copy "\\server\Updates\UpdatesFrontEndFile.mdb" "C:\databases\MyMDB.mdb"
goto end
:FileNotFound
REM Do nothing.   No updates
:end

Just put your code in a file with the .BAT extension and then call it from your startup. Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[THoey]

Please realize the the second line that says "goto FileFound" is actually a part of the first line, just wrapped. Same with the line after the copy command... Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.