Access Application 1

[Jonathan123]

Hi, Anyone know how to make an access application created in VB truly invisible to the user so it does not even show in the taskbar?

Also, any ideas on how to kill the instance of the access application itself? Not just close the current database with obj.application.closecurrentdatabase but kill the actual application
Thanks,

 

[MikeCox]

Sure, you can create the Access application like this:

'Note: requires reference to Access X.0 object library

Dim MSAccess as Access.Application
Set MSAccess = CreateObject("Access.Application&quot

MSAccess.OpenCurrentDatabase "MyDBPath.mdb"

'As long as you don't include a MSAccess.Visible = True, the App won't show up in the taskbar (although it will appear in the Ctrl+Alt+Del list) When you're done, use Set MSAccess = Nothing to get rid of it.

Good luck!

-Mike
Difference between a madman and a genius:
A madman uses his genius destructively,
A genius uses his madness constructively.

 

[Jonathan123]

Thanks Mike for your last point. Regarding the first, it shows up in the task bar as minimized.
Perhaps someone knows a work around
Thanks