Application.AutomationSecurity command and Access 2003

[J Baird]

I have a lot of macros and VB apps that open MS Access 2000 databases.

This worked great until I started using Access 2003 (and it's new security
model).

In a Visual Basic app, I've been issuing the "Application.AutomationSecurity
= MsoAutomationSecurityLow" command, then opening an Access 2003 database.
Even with that command, the user still has to click the [Open] button, to
get the Access file to open. They don't want to click the [Open] button!

Does anyone know a way to make the MsoAutomationSecurityLow setting work
from the VB app? I don't want to have to work with a Digital Ceritificate.

 

[Brendan Reynolds]

I don't have VB 'classic' installed on this PC, but the following worked for
me when executed from a VBA module in Microsoft Word (with references to the
Access 11 and Office 11 object libraries).

Public Sub TestSub()

Dim app As Access.Application
Set app = New Access.Application
app.AutomationSecurity = msoAutomationSecurityLow
app.OpenCurrentDatabase "c:\usenet\test.mdb"
app.Visible = True
Set app = Nothing

End Sub