Results 1 to 3 of 3
  1. #1
    Ant_Snell is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Jul 2021
    Location
    UK
    Posts
    47

    Trusted location "Choose another location or specific folder"


    I have just installed a DB for a small business; It is split with the back-end tables sitting on a virtual server (accessed via a VPN) and the front end on the client PC/laptop. When ever they log in they get the Access warning “Macros could be harmful to your computer” I have tried to add the virtual drive to Microsoft Office Trusted Locations list but keep getting “ The path you have entered cannot be used as a Trusted Location for security reasons. Choose another location or specific folder.” Any ideas how to get round this or another what to stop the macro warning? Thanks

  2. #2
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    2,107
    Try adding the folder not the whole drive as a trusted location, or (and I don't normally recommend this) map the folder as a drive on the client machine.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    9,445
    I would also check that the folder where the front end is located is also trusted.

    Not sure about virtual drives but in order to trust a folder on a network the 'allow trusted locations on my network' also needs to be ticked

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

Similar Threads

  1. Replies: 3
    Last Post: 09-08-2021, 11:17 AM
  2. Replies: 7
    Last Post: 08-07-2017, 03:22 PM
  3. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  4. Replies: 17
    Last Post: 06-04-2012, 05:11 PM
  5. location of "enter parameter value" box
    By dcjohnso11 in forum Programming
    Replies: 1
    Last Post: 06-25-2010, 11:36 AM

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