Access and WScript

[Rob]

Good afternoon,
Has anyone experienced difficulty with calling Access97
from windows scripts?
We have a Windows 2000 Server with several scheduled tasks
running seperate portions of the same script at different
time intervals through the day. Periodically, these tasks
overlap and sometime hang up without completing, the task
continues to show as running.
Has anyone had a problem similar to this involving,
Windows scripting, Access 97, and Win 2000?

 

[Danny J. Lesandrini]

Here are some examples from my site ...

Script to compact MDB
http://www.amazecreations.com/datafast/GetFile.aspx?file=WSHCompactMDB.zip

Script to execute query
http://www.amazecreations.com/datafast/GetFile.aspx?file=WSHExecuteQuery.zip

Script to export Access table in html format
http://www.amazecreations.com/datafast/GetFile.aspx?file=WSHExportToHTML.zip

Script to export VBA module to file
http://www.amazecreations.com/datafast/GetFile.aspx?file=WSHWriteModule.zip

Script to back up Access mdb file
http://www.amazecreations.com/datafast/GetFile.aspx?file=WSHBkup001.zip


There are other scripts at my site, but they have to do with Word and Outlook
http://www.amazecreations.com/datafast/Download.aspx

 

[Rob]

Thank you for the response. But the issue is not with
writing the scripts. The problem appears to be that the
scripts to not complete and leave the task running or the
scripts do not cooperate well with Access 97.