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.Application
objAccess.Visible = 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]]

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...b;en-us;832510

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

"Geoff" wrote:

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.Application
objAccess.Visible = 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