I need to run a vbscript from MS Access 2003. I generate the script in VBA and store it in an external vbs file. I then want to run/open/launch the vbs file. (The file checks to see if the Access database's ldb exists. If so, it sleeps and rechecks until the ldb doesn't exist. It then copies the database to another location.)
I can't seem to get the proper syntax to run/open/launch the vbs file from VBA. The script works correctly - I run it manually when Access VBA says it can't launch or find the script. Any suggestions?