Results 1 to 9 of 9
  1. #1
    panoss is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Oct 2014
    Posts
    59

    Can't remove security warning on Access file startup

    I have Access 2003 in Win2k.

    I've created a .reg file (which adds a registry key in the registry), this is it's code:
    Code:
    Windows Registry Editor Version 5.00
    
    [HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Access\Security\Trusted Locations\Location20]
    "Path"="E:\\DBs\\"
    The key is indeed added in the registry, I checked it out.
    Click image for larger version. 

Name:	Reg.jpg 
Views:	38 
Size:	20.9 KB 
ID:	18548
    The directory of my Database is 'E:\DBs'.


    It's supposed to remove the security warning (look here), but it doesn't!
    What can I do?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    2003 does not have "Trusted Locations". Trusted locations started with version 2007.


    I believe the only way to avoid the warnings with 2003 is to have a signed cert or to enable "Sandbox Mode". You can create your own digital cert on a machine with a full version of Access. The cert created will be good for that machine only. Otherwise, certs are purchased for a lot of money (not even sure if this is common practice anymore).


    To enable sandbox mode, search MSDN for Access2003 Sandbox Mode Registry

  3. #3
    panoss is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Oct 2014
    Posts
    59
    I 've created a digital certificate but I guess it 'll be good for my machine only......not for the client's.
    I had tried the "Sandbox Mode" but had no success.

  4. #4
    panoss is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Oct 2014
    Posts
    59
    My Msjet40.dll version is 4.0.8015.0 (Service Pack 8 (SP8)) so I guess I have the correct Jet installed.
    I set the value of HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\engi nes\SandboxMode to 3. (don't know why appears the space in word 'engines')
    But the security warning still appears.

  5. #5
    panoss is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Oct 2014
    Posts
    59
    I guess I 'll have to 'play with two registry keys (which probably are different in my client's machine for he 's running Access 2007 Windows 7):
    [[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\11.0\A ccess\Security]
    "Level"=dword:00000001

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes]
    "SandBoxMode"=dword:00000002

  6. #6
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I do not know for sure but I will guess that the version that is running on the client machine will determine whether or not Trusted Locations are available. So, if the client has a full version or a Run Time version of Access 2007 and they open an MDB file, Trusted Locations will kick in.

    If the client is using Access 2007 or greater to open Access files, I would edit the registry for Trusted Locations.

    Here is a tool I built for this purpose.

    I have been using it for 2010 and 2013 RT and full versions. If you use it in a full version, launch it and add it to Trusted Locations (ironic, I know) then close and launch it again.

    It is the VBA that does the job. You could incorporate the VBA into an app or just use the DB file as is.
    Attached Files Attached Files

  7. #7
    panoss is offline Advanced Beginner
    Windows 2K Access 2003
    Join Date
    Oct 2014
    Posts
    59
    Thank you! Sorry for the late answer, I just saw it.
    I 'll give it a try.

    Edit:
    Ooops!! It's an Access 2010 file I guess, I can't open it, I have Access 2003.
    Could you convert it to 2003?

  8. #8
    SoreGums is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    10
    I want to simply detect the trust centre getting in the way and allow the user to then
    - just click "trust"
    - close access
    - open the db again

    right now all my automatic stuff is screwing this up and won't allow the user to get to the "trust" button.

    so i can get past it by opening access, then open the file holding shift (to bypass the autoexec), click trust, close and reopen....

    Is there a way to detect that the trust centre has got in the way?

  9. #9
    SoreGums is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    10
    figured out a way to handle what i was talking about gracefully http://youtu.be/maW3tOsOsiQ

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

Similar Threads

  1. MS Access triggering Outlook Security warning
    By Amiga1200 in forum Programming
    Replies: 5
    Last Post: 05-22-2014, 11:24 PM
  2. Remove WARNING messages?
    By taimysho0 in forum Queries
    Replies: 4
    Last Post: 12-14-2011, 05:06 PM
  3. security warning
    By wthoffman in forum Access
    Replies: 3
    Last Post: 02-26-2011, 09:22 AM
  4. How do i remove access 2010 security
    By sam49 in forum Security
    Replies: 26
    Last Post: 11-15-2010, 10:22 AM
  5. Security Warning
    By mojo53777 in forum Security
    Replies: 0
    Last Post: 11-16-2007, 06:23 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