Albert D. Kallal windows script for automation of access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
To be safe, try putting

accessApp.CloseCurrentDatabase

before the accessApp.Quit line.
 
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!
Click to expand...
 
Back
Top