have any way to disable "Security Warning" ?

[Dlovan-IT]

hi Access World

i'm new to access , and i need one of the common security in access , for example i create a new project and all the data has been secure but when open the database in start up that Security warning is appear
however , now i want to disable that message box using vba or modules , please who have an information answered .


thanks for team ...

 

[missinglinq]

If you could disable security through code in an Access app, there wouldn't be much point in having security, would there? To disable the security so that you don't need to clear the messagebox each time, you need to declare the Folder where your File resides as 'Trusted.'

To "Trust" your folder, click:

• Office Button (top left)
• Access Options (bottom of dialog)
• Trust Center (left)
• Trust Center Settings (button)
• Trusted Locations (left)
• Add new Folder/location (button)

Linq ;0)>

 

[Dlovan-IT]

my friend thanks for reply

no my fiend i want to disable trusted center by vba or mudoles not important which one of them , look the picture attachment

 

[missinglinq]

my friend thanks for reply

...i want to disable trusted center by vba or mudoles...

To disable the security popup, follow the instructions I gave you and declare the Folder holding the database as 'Trusted.'

 

[TJPoorman]

You can also go to the Trust Center and Macro Settings. Then select Enable All Macros.

This is only recommended if you are very careful of what you download and open.

 

[pr2-eugin]

I have this in my application documentation..

To add a file to a trusted location, please perform the following steps after choosing to open the file.

1. Click on the ‘File’ tab at the Left-Top corner and select Options from the menu list.
2. In the following window ‘Access Options’; select the option ‘Trust Center’ at the very end of list; and click the Trust Center Settings…
4. 
5. You will face another window that has a list of options; select ‘Trusted Locations’.
6. Since you have your Form in the local drive of your computer, you have to add this location as one of the trusted locations that you will be working on. Use the ‘Browse’ button to look for the location of the placed Form.
7. Click OK, and the location will be trusted. Click OK again to exit the Trust Center and OK to exit the Access Options.
8. In order for the changes to take effect the Access should be closed and reopened.

 

[Dlovan-IT]

ok , thanks fo all my friend thanks for answering my question & thanks for heartfelt ...


but have any code that do it as the same ?

 

[missinglinq]

Listen to me once more!!! If you could do this using code, anyone who wanted to have you download a database with malicious content in it could simply use code to disable the security warning, making the security feature useless!!!

Linq ;0)>

 

[Dlovan-IT]

ok ok my dear @missinglinq , please don't worry ..


my problem was here anyone can edit my design form and edit table edit report edit everything, if put database without folder the security warning another again appear....!

what is your solution for no one can edit my project database it mean locked database ?

 

[TJPoorman]

Create an ACCDE file

 

[Dlovan-IT]

look when i create an ACCDE that message box was appears i don't no why i can't create !

 

[pr2-eugin]

Try Compact & Repair. Then follow a Compile of VBA Code. If there are any errors correct them. Now try creating a ACCDE.

If the error persists try a Decompile on your backup..

 

[Galaxiom]

This security debacle is the result of Microsoft's decision to drop the ability to digitally sign the code in the accd* format.

Go back to md* where Access documents can still be signed and the whole problem disappears. Trusted Folders is clumsy security hole ready for a bus to drive through.

 

[Dlovan-IT]

@pr2-eugin i do Compact & Repair , but the error was appear again !