PC Review


Reply
Thread Tools Rate Thread

Closing a Database

 
 
Bunky
Guest
Posts: n/a
 
      27th Apr 2009
I have written some VB Scripting to run some code via Windows Scheduler when
I am fast asleep. Everything works well except for one very minor point.
After my macro has finished, I would like it to close the database and exit
but I cannot seem to accomplish this. Here is my code.

Public Function Kent()
dim accessApp

set accessApp = createObject("Access.Application")

accessApp.OpenCurrentDatabase("\\iocc-server\dcs\kenttesting\testblank.mdb")

accessApp.Run "RunPrintTest1"
accessApp.Quit
set accessApp = nothing
End Function

Any ideas where I am wrong?

Thanks in advance for the assistance!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Closing another database with VBA Gaetan Microsoft Access 1 5th Feb 2008 09:20 AM
closing database =?Utf-8?B?bWhtYWlk?= Microsoft Access Form Coding 2 26th Jan 2007 03:51 AM
closing another database =?Utf-8?B?THVpcw==?= Microsoft Access VBA Modules 1 30th Mar 2006 10:29 PM
RE: VBA for Closing Database =?Utf-8?B?RnJhbmsgV2FnbmVy?= Microsoft Access Form Coding 0 22nd Sep 2005 05:23 PM
Multiple OutputTo (Called on Closing Form) Fails on Closing Database John Andrews Microsoft Access Macros 3 21st May 2004 08:54 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:41 PM.