I get a run-time error -2147417848. Automation error. The object invoked has disconnected from its clients. Although that may have been caused by appAccess.Quit in a "bad" location.
I also get a run time error 440 automation error. Although it ran flawlessly the first time after I added in the appAccess.visible = true. Now one of the databases is stuck in read only again when I tried to run it a second time and it's failing on the appAccess.Run "PerformSQL", DeleteStatement this time as if it's dying in the Access SQL module because the file that was open once before is now read only.
Bookmarks