Q: Automation

[Geoff]

Hi

I'm opening an Access object using Automation. I have two problems I need to
sort out. Firstly, I don't want Access to be visible. I have tried

Dim objAccess As New Access.Applicat ion
objAccess.Visib le = False

but Access still appears. Further, there is a security warning message on
startup with "This file may not be safe...." etc. Is there a way, at
runtime, to stop this appearing?

Thanks in advance

Geoff

[Ken Tucker [MVP]]

RE: Q: Automation

Hi,

To prevent the security warning on the access database you either
need to lower the security settings or add a digital signature to the acess
database. I would go with the digital signature.

http://support.microsoft.com/default.aspx?scid=kb;en-us;832510

Ken
-------------------

"Geoff" wrote:
[color=blue]
> Hi
>
> I'm opening an Access object using Automation. I have two problems I need to
> sort out. Firstly, I don't want Access to be visible. I have tried
>
> Dim objAccess As New Access.Applicat ion
> objAccess.Visib le = False
>
> but Access still appears. Further, there is a security warning message on
> startup with "This file may not be safe...." etc. Is there a way, at
> runtime, to stop this appearing?
>
> Thanks in advance
>
> Geoff
>
>
>[/color]