PC Review


Reply
Thread Tools Rate Thread

I am trying to open MS access remotely without seeing the security

 
 
Armele
Guest
Posts: n/a
 
      10th Jul 2009

I would like to know how/wher to apply the following code in my application
in order to suppress the security warning? (see code below)




Const cDatabaseToOpen = "path\App_name.mdb"

On Error Resume Next
Dim AcApp
Set AcApp = CreateObject("Access.Application")
If Val(AcApp.Version) >= 11 Then
AcApp.AutomationSecurity = 1 ' msoAutomationSecurityLow
End If
AcApp.Visible = True
AcApp.OpenCurrentDatabase cDatabaseToOpen
If AcApp.CurrentProject.FullName <> "" Then
AcApp.UserControl = True
Else
AcApp.Quit
MsgBox "Failed to open '" & cDatabaseToOpen & "'."
End If


 
Reply With Quote
 
 
 
 
Tom van Stiphout
Guest
Posts: n/a
 
      11th Jul 2009
On Fri, 10 Jul 2009 07:44:01 -0700, Armele
<(E-Mail Removed)> wrote:

If that worked, malware could do the same thing.

-Tom.
Microsoft Access MVP


>
>I would like to know how/wher to apply the following code in my application
>in order to suppress the security warning? (see code below)
>
>
>
>
>Const cDatabaseToOpen = "path\App_name.mdb"
>
>On Error Resume Next
>Dim AcApp
>Set AcApp = CreateObject("Access.Application")
>If Val(AcApp.Version) >= 11 Then
> AcApp.AutomationSecurity = 1 ' msoAutomationSecurityLow
>End If
>AcApp.Visible = True
>AcApp.OpenCurrentDatabase cDatabaseToOpen
>If AcApp.CurrentProject.FullName <> "" Then
> AcApp.UserControl = True
>Else
> AcApp.Quit
> MsgBox "Failed to open '" & cDatabaseToOpen & "'."
>End If
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS ACCESS cannot open file - security problems dan shelby Microsoft Access 2 29th May 2007 09:03 PM
Remotely get WMI info from Security Center? Jimmy B Windows XP WMI 3 11th Jan 2007 03:10 AM
Can't open db from Excel due to Access security Ian Baker Microsoft Access Security 7 20th Aug 2004 01:51 PM
Re: Read only Access of Local security policies remotely Steven Umbach Microsoft Windows 2000 Security 2 4th Aug 2004 02:51 AM
Named pipe security and preventing access remotely Ian Poynter Microsoft Windows 2000 Security 1 20th Dec 2003 07:40 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:48 AM.