Albert D. Kallal windows script for automation of access

P

patti

I have used Albert D. Kallal's script below:

dim accessApp
set accessApp = createObject("Access.Application")
accessApp.OpenCurrentDataBase("C:\some path name\someMdb.mdb")

accessApp.Run "TimeUpDate"
accessApp.Quit
set accessApp = nothing

Does this close out access? I figure that is what quit does.... but i am
left w/ the.ldb file and the db unable to be opened in exclusive mode.

any help would be appreciated.

patti
 
D

Douglas J. Steele

To be safe, try putting

accessApp.CloseCurrentDatabase

before the accessApp.Quit line.
 
P

patti

Douglas J. Steele said:
To be safe, try putting

accessApp.CloseCurrentDatabase

before the accessApp.Quit line.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)





thanks doug!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top