<div>
Hi capricorn1,<br />
<br />
It ran great but the database didn't close and the svchost.exe continued to run. is there another command that I need in this script file or is the error in my VBA code in the macro?<br />
<br />
scurvylion
</div>


Hi capricorn1,

It ran great but the database didn't close and the svchost.exe continued to run. is there another command that I need in this script file or is the error in my VBA code in the macro?

scurvylion

<div>
if your vba codes does not include to close the application<br />
<br />
docmd.quit &nbsp; ' you can add this at the end of the vba code<br />
<br />
or<br />
<br />
in the macro<br />
<br />
action<br />
runcode<br />
quit &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'add this 
</div>


if your vba codes does not include to close the application

docmd.quit   ' you can add this at the end of the vba code

or

in the macro

action
runcode
quit           'add this

<div>
Works great! Thanks for your help - appreciate it very much!
</div>


Works great! Thanks for your help - appreciate it very much!

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
This is part of a project that I am doing. I am at the stage where I have successfully automated the import of .csv files into an Access database (with lots of help from EE). Now I want to automate the process so that every night at say 2:00 AM a VB script runs and opens the Access 2007 database and runs a macro (which calls the VBA code to update the database) and then closes.<br />
<br />
I believe that this should be pretty easy to operationalize but I have no experience working with VB scripts at all so any help that I can get would be most appreciated.<br />
<br />
Thanks,<br />
scurvylion
</div>
</div>


Hi,

This is part of a project that I am doing. I am at the stage where I have successfully automated the import of .csv files into an Access database (with lots of help from EE). Now I want to automate the process so that every night at say 2:00 AM a VB script runs and opens the Access 2007 database and runs a macro (which calls the VBA code to update the database) and then closes.

I believe that this should be pretty easy to operationalize but I have no experience working with VB scripts at all so any help that I can get would be most appreciated.

Thanks,
scurvylion

Using VB script to run Access macro at specific time

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.