How to disable access security notice "A Potential security concern has been identified"
You have to set their computer to be a trusted source. In order to get around this issue, you will need to create a Digital Certificate. Digital Certificates are good only on the computer they are created on, so if this database will be used on multiple computers then each one will have to create a Digital Certificate.
To do this, you will need to perform the following tasks:
Click on Start -> All Programs -> Microsoft Office -> MicrosoftOffice Tools -> Digital Certificate For VBA Projects (If you don’thave this, you will need to contact your IT Dept.)
Enter a Certificate Name. Make it obvious like MyProgramName and Click OK
- Open the Access database which contains the security warning you want to bypass
- Go into the Design View of any Module
- Click on Tools -> Digital Signature
- Choose your Digital Certificate you created in Step 2
- Save and close the database
- Re-Open the database. You will now be prompted with a different Security Warning that states the file has been digitally signed.
- Check off the “Always trust files from this publisher…” box and click the Open button
- All subsequent times you enter this database, you will not be prompted with a security warning.
Note - I wrote the above for our company based on Office 2003. If you're using a more recent version, the instructions may vary somewhat.
other way is following:
click on file and then options
click on trust center and then trust center settings on the right
then click on trusted locations and add new location
browse for the location and save.
that's it.. done.. now no more warnings..
That is a standard warning to indicate the file you are opening has web links and macros.If you trust the file, just say OK or “Allow”
You can control if this message is displayed: Office button > Excel Options button > Trust Center > Trust Center Settings button (I have no idea why they have this extra button, DUMB DESIGN! )
More Information can be found here