I am making a vb6 front end (menu) to several access97 programs (.mdb with startup form). The problem is i need the vb code to suspend execution until the user closes access.
The Set appObj = GetObject(, "Access.Application") to check if it's running doesn't seem to work cause i think the reference it's returning won't let the user shut access down.
The Detect MS Office tip will let me see if access is running or not, but doesn't seem to let the user close it either.
Any help would be Greatly appreciated!
-Marti