Automatic Update of FE

[Kenln]

I am using Bob Larson's Automatic Updating program.

Cutting out some of the code

' sets the file name of the batch file to create
TestFile = CurrentProject.Path & "\UpdateDbFE.cmd"

' creates the batch file
Open TestFile For Output As #1
Print #1, "Echo Off"
Print #1, "ECHO Deleting old file"

[Blah] [Blah] [Blah]

Print #1, "CLICK ANY KEY TO RESTART THE ACCESS PROGRAM"
Print #1, "START /I " & """MSAccess.exe"" " & strRestart
Close #1
'Exit Sub
' runs the batch file
Shell TestFile

'closes the current version and runs the batch file
DoCmd.Quit

Everything worked fine until they switched me to a laptop.

Now everything appears fine, the shell file is created but it does not run. I have to run it (double click) manually. Would anyone know why? What would be different???? The code I have, while some additions have been made, has been working fine for a year and all of the sudden, new machine and now it doesn't.

It is no problem for me but this happens to the users then I will not be a friend of our IT dept anylonger.

 

[boblarson]

What operating system are you running on the laptop?

 

[Kenln]

XP Service Pack 2

 

[boblarson]

Is that the same Windows version on the other computers that do work? I'll have to try to see if I can find something about that, unless someone else has some ideas.

 

[Kenln]

I have two files it copies.
A login file and the FE Application file.

The login file calls the FE Application file (which is a password protected db).

I can confirm the FE application file copies from the server. I have not confirmed the login file copies.

But it does not start the access program. Could this be a timing issue with a fast or slow network?

 

[Kenln]

Same OS.

When I had a desktop the 'My Doc' was server based, now it is physically local. Other than that I am unsure.

 

[boblarson]

It COULD be a timing issue. Maybe if you increase the ping amount in the command code that is built. I think it is currently 2 seconds. Maybe you should try bumping it up to 5 seconds to test.

 

[Kenln]

how do you do that??

 

[Kenln]

If I put a pause in the code,
Which means I have to tab to the dos window and press the space bar or enter key
it works.

So I think this is a timeing issue of sorts.
Do you know how to put a delay in the shell file?

 

[Kenln]

Googled Ping and it works great thank you.

 

[boblarson]

Glad you got it. Sorry I couldn't respond quicker but I was too busy at work.