How to hide another Access instance

  • Thread starter Thread starter Sergey Poberezovskiy
  • Start date Start date
S

Sergey Poberezovskiy

Hi,

I have the following piece of code:

Dim oAccess As Access.Application
Set oAccess = New Access.Application
oAccess.OpenCurrentDatabase vsDatabaseName
' some other code
oAccess.CloseCurrentDatabase
oAccess.Quit acQuitSaveNone

Whenever I run it, another instance always opens on top of
the running application.

Is there any way to not hide it from the user?

Any help is much appreciated
 
i'm not certain, but I think something like this would
hide the other instance from the user:

oAccess.Visible = False

It's what I've used for hiding Excel applications before,
so it might work for your application in Access.

good luck!
 
Rob,

When oAccess is created through Automation, it's Visible
property is False by default. And I checked, it is False.

I am using Access 2003.
I tried to reproduce similar behaviour on another PC with
Access 2000, and another instance does not seem to appear.

Could that have something to do with 2003?
 
Back
Top