Results 1 to 4 of 4
  1. #1
    bignate is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    47

    Question What is the best solution for enabling VBA and Macros

    Hi

    Below are the ways I know of getting around the 'Security Warning - Certain content has been disabled from the database' , however I'm not really sure which one would be best for the situation I am in. The application will be used in the work place and stored in a network folder.

    Making a Trusted Folder - I would use this, however the database is going to be shared in a network folder so the folder would have to be trusted on every computer which isn't really possible considering the amount of people and computers that would need to access it. Does anyone know if its possible to make a network folder trusted by default on every computer?

    Split the Database - I have seen this suggested before, but when splitting the database the front end would still have to be in a trusted folder so this wouldn't fix the problem as far as I know.



    Digital Signature - Seems like the best solution because I think you only enter the password once then the application is always trusted but I'm not really sure how this works

    If any one has any other solutions then please let me know.

    Thanks

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows XP Access 2003
    Join Date
    Aug 2013
    Posts
    7,862
    RegEdit.zip
    I built this app to automate adding the necessary reg keys to client PC's. I have tested on 32bit and 64bit machines running 32bit Access. I have not tested it with 64bit Access.

    Maybe you could incorporate some of the code to use CurrentPath. The way the DB is currently, you need to paste a path into a textbox and then select the options to create the appropriate keys. There are different keys and settings for network folder vs local drive, settings for subfolders allowed, etc.

  3. #3
    bignate is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    47
    Thank you, I will try doing that

  4. #4
    SoreGums is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    10
    Figured out a way to handle this gracefully - http://youtu.be/maW3tOsOsiQ

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Enabling commands for different users
    By glen in forum Forms
    Replies: 28
    Last Post: 10-11-2012, 03:36 PM
  2. Enabling fields in form
    By Kivan in forum Programming
    Replies: 8
    Last Post: 08-22-2012, 03:44 AM
  3. Enabling and disabling fields
    By SgtSaunders69 in forum Programming
    Replies: 9
    Last Post: 12-27-2011, 06:11 PM
  4. Enabling Option Groups using Macros
    By mnsemple83 in forum Forms
    Replies: 1
    Last Post: 07-15-2011, 06:11 PM
  5. Enabling a control and moving to a new tab in vba
    By MuskokaMad in forum Programming
    Replies: 1
    Last Post: 03-14-2010, 05:30 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums