Shell command

[Steve_in_Kent]

I'm attempting to use an auto update program i found on the net. dates back a few years but appears to work. (mostly).

The version check occurs in the main program, and an auto update mdb is run.

In this mdb, to run the new version of the database that has been replaced, the shell command is used. this is the code:-

strcmd = "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE " & Chr(34) & "C:\Documents and Settings\All Users\DL-Special.mdb" & Chr(34)

'strcmd = strcmd + " /wrkgrp S:\Document Library\SYSTEM.mdw"
'strcmd = strcmd + " /user AUser /pwd Whatever"

Call Shell(strcmd, vbNormalFocus)
DoEvents: DoEvents: DoEvents

The code above seems to work, (adding the chr(34)s)... however, i also need to add the workgroup and user pass to the strcmd variable, i've tried various ways, but cannot seem to get it just right.

[HansV]

Does it work if you use

strcmd = strcmd & " /wrkgrp " & Chr(34) & S:\Document Library\SYSTEM.mdw" & Chr(34)
strcmd = strcmd & " /user AUser /pwd Whatever"

[Steve_in_Kent]

strcmd = strcmd & " /wrkgrp " & Chr(34) & "S:\Document Library\SYSTEM.mdw" & Chr(34)
strcmd = strcmd & " /user AUser /pwd Whatever"

Added a speech mark shown above, and its working.

cheers hans. the amount of differing variations i went through to try to get it to work

[HansV]

Sorry, should have noticed that. Glad you got it working.

[grovelli]

Does the auto update mdb close after opening the new version of the database?