How to hide another Access instance

[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

 

[Rob]

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!

 

[Sergey Poberezovskiy]

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?

 

[John Nurick]

Hi Sergey,

Have you checked out the KB articles on using Access as an Automation
server?
http://support.microsoft.com/?id=147816
http://support.microsoft.com/?id=210111 (Access 2000)
I haven't checked to see whether there's one for Access 2003, but if not
the one for 2000 probably applies.