Launching Access .mdb file - Using followhyperlink vs. creating an AccessObject

[microb0x]

First some quick background regarding the application I have a
question regarding:

I have an application that when launched does a check whether or not
its the most current version of the Front End that I have in
production. If the front end is out of date, it closes, and launches
another access .mdb file that serves as an update utitlity.

This update utility that is opened is set to hide the main Access
container window, API courtesy of Dev Ashish, for example:

fSetAccessWindow(SW_HIDE)

When I use the following code to launch this update utility and close
the front end, everything works perfect. The front end closes without
problem, the update utility opens and the main Access container window
is hidden:

'Launch VersionControl Utility then close current app
Set objAccess = New Access.Application
objAccess.Visible = True
objAccess.OpenCurrentDatabase vPath2
DoCmd.Quit

This method of course requires a reference to be set. I am running
into an issue where only certain computer's generate errors at this
point and Access bombs and closes. I'm assuming this is due to a
missing or corrupt dll being referenced. I have not confirmed this
yet.

In an effort to eliminate this possibility I was trying to launch the
update utility using two other methods. The first method was using
application.followhyperlink This would also be the ideal solution for
me if I can get it working with anyones assistance. What happens when
I use this method is the update utlity is not hiding the main Access
container window. So there is my problem.

Does anyone have any insight into this?

The second method I tried to use to launch the update utility was
using the ShellExecAPI also courtesy of Dev Ashish. When I try this
method the front end seems to just hang and do nothing, trying to
manually close this Access file causes the application to stop
responding and I end up ending the task to continue. The update
utility never opens up in this case.

Does anyone have any insight into this as well?

I apologize, I know this post is a bit lengthy but I wanted to include
as much detail as possible hoping someone knows why this is happeneing
or has experienced something similar.

 

[Guest]

Have you tried using Access MVP Tony Toews' AutoFE Updater? You might find
this a lot easier to implement, versus the method that you are attempting to
use now.

Auto FE Updater
http://www.granite.ab.ca/access/autofe.htm


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[microb0x]

While that is an excellent suggestion and Tony's AutoFE Updater works
quite well (I've used it in other projects), I'd prefer to use my
customized update utility.

My utility works perfect as far as updating the front end file and
copying down any other needed files from the server. The only real
issue I have is getting access to hide the main Access container
window when that .mdb is opened using application.followhyperlink from
another .mdb

Can anyone assist with that specifc issue?