How can I disbale the trusted security setting in MS Access 2007?

[Help]

Hi all
Please help me,
I have to alter the table in MS Access but I get an error message "The
action or event has been blocked by Disable mode." I searched it on net it is
due to the security option. Now how can I disable the security alert form my
MS Access database permanently so that I can alter that table to add the
column??

Also Do tell me How can i disbale the trusted security using the VBscript?

Thanks and Regards

 

[strive4peace]

you cannot 'disable' the security ... but you can set up 'trusted'
locations -- this tells Access that files in these locations are trusted
and it is okay to run code and make changes

here are some references for you:

MVP Tom Wickerath also has a web page for managing macro protection:

Dealing with the Trust Center (Access 2007), by Tom Wickerath
http://www.accessmvp.com/TWickerath/articles/trust.htm


MVP Garry Robinson made a video about how to set up a trusted location
for your databases in Access 2007:

http://vb123.blogspot.com/

~~
Create, remove, or change a trusted location for your files
http://office.microsoft.com/en-us/access/HA100319991033.aspx

~~
Configure trusted locations and trusted publishers settings in the 2007
Office system
http://technet2.microsoft.com/Offic...122c-42f2-a4a5-1f09a066558f1033.mspx?mfr=true

~~
Bob Larson: Quick tutorials
How to enable code and macros in Access 2007
http://www.btabdevelopment.com/main...owtoenablecodeandmacros/tabid/57/Default.aspx


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
have an awesome day
*

 

[Arvin Meyer [MVP]]

Hi all
Please help me,
I have to alter the table in MS Access but I get an error message "The
action or event has been blocked by Disable mode." I searched it on net it
is
due to the security option. Now how can I disable the security alert form
my
MS Access database permanently so that I can alter that table to add the
column??

Also Do tell me How can i disbale the trusted security using the VBscript?

It's VBA, but you can adapt it easily enough:

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