Access 2007 Runtime Security Issue

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Rocky
    #1

    Access 2007 Runtime Security Issue

    My Access 2007 file fails to open on a machine with the 2007 Access
    runtime version installed. It comes up with a Security alert message.
    Is there a security setting in the Access Database that needs to be
    enabled to run the code and macros?

    Tags: None
    • King Ron
      #2
      Re: Access 2007 Runtime Security Issue

      As a security measure, by default Windows will not allow databases
      created on external and untrusted machines to automatically open. It's
      probable that you need to authorize the Access application.

      In Windows explorer, Right-click on the .mdb or .mde file and select
      'Properties'. On the General tab there should be a button to authorize
      your application to open.

      Ron, King of Chi


      On Aug 13, 6:29 am, Rocky <consult...@ran dalstewart.comw rote:
      My Access 2007 file fails to open on a machine with the 2007 Access
      runtime version installed. It comes up with a Security alert message.
      Is there a security setting in the Access Database that needs to be
      enabled to run the code and macros?

        Comment

        • Rocky
          #3
          Re: Access 2007 Runtime Security Issue

          On Aug 13, 4:51 pm, King Ron <KingRonPoindex ...@covad.netwr ote:
          As a security measure, by default Windows will not allow databases
          created on external and untrusted machines to automatically open. It's
          probable that you need to authorize theAccessapplic ation.
          >
          In Windows explorer, Right-click on the .mdb or .mde file and select
          'Properties'. On the General tab there should be a button to authorize
          your application to open.
          >
          Ron, King of Chi
          >
          On Aug 13, 6:29 am, Rocky <consult...@ran dalstewart.comw rote:
          >
          >
          >
          MyAccess2007fil e fails to open on a machine with the2007Access
          runtimeversion installed. It comes up with a Security alert message.
          Is there a security setting in theAccessDataba se that needs to be
          enabled to run the code and macros?- Hide quoted text -
          >
          - Show quoted text -
          Thanks Ron. I have opened the properties/security tab and given all
          users full permission and re-booted the system.
          Still comes up with the same message.

            Comment

            • Sascha Trowitzsch
              #4
              Re: Access 2007 Runtime Security Issue

              Hi Rocky,

              "Rocky" <consulting@ran dalstewart.coms chrieb im Newsbeitrag
              news:1187076029 .197592.71310@q 4g2000prc.googl egroups.com...
              On Aug 13, 4:51 pm, King Ron <KingRonPoindex ...@covad.netwr ote:
              >As a security measure, by default Windows will not allow databases
              >created on external and untrusted machines to automatically open. It's
              >probable that you need to authorize theAccessapplic ation.
              >>
              >In Windows explorer, Right-click on the .mdb or .mde file and select
              >'Properties' . On the General tab there should be a button to authorize
              >your application to open.
              >>
              >Ron, King of Chi
              >>
              >On Aug 13, 6:29 am, Rocky <consult...@ran dalstewart.comw rote:
              >>
              >>
              >>
              MyAccess2007fil e fails to open on a machine with the2007Access
              >runtimeversi on installed. It comes up with a Security alert message.
              Is there a security setting in theAccessDataba se that needs to be
              enabled to run the code and macros?- Hide quoted text -
              >>
              >- Show quoted text -
              >
              Thanks Ron. I have opened the properties/security tab and given all
              users full permission and re-booted the system.
              Still comes up with the same message.
              The security system changed in A2007.
              You have to determine a Trusted Location (folder) for your accdb.
              In full version that's done by adding the place to a list under Access
              options. Runtime has no office menu button. So you have to add the folder to
              the registry manually adding a locations key, e.g.:

              [HKEY_CURRENT_US ER\Software\Mic rosoft\Office\1 2.0\Access\Secu rity\Trusted
              Locations\Locat ion1]
              AllowSubFolders (REG_DWORD) = 1
              Path (REG_SZ) "C:\MyTrustedDa tabaseFolderNo1 "

              [HKEY_CURRENT_US ER\Software\Mic rosoft\Office\1 2.0\Access\Secu rity\Trusted
              Locations\Locat ion2]
              AllowSubFolders (REG_DWORD) = 1
              Path (REG_SZ) "C:\MyTrustedDa tabaseFolderNo2 "

              Ciao, Sascha


                Comment

                • Rocky
                  #5
                  Re: Access 2007 Runtime Security Issue

                  On Aug 14, 11:15 am, "Sascha Trowitzsch" <n...@moss-soft.dewrote:
                  Hi Rocky,
                  >
                  "Rocky" <consult...@ran dalstewart.coms chrieb im Newsbeitragnews :1187076029.197 592.71310@q4g20 00prc.googlegro ups.com...
                  >
                  >
                  >
                  >
                  >
                  On Aug 13, 4:51 pm, King Ron <KingRonPoindex ...@covad.netwr ote:
                  As a security measure, by default Windows will not allow databases
                  created on external and untrusted machines to automatically open. It's
                  probable that you need to authorize theAccessapplic ation.
                  >
                  In Windows explorer, Right-click on the .mdb or .mde file and select
                  'Properties'. On the General tab there should be a button to authorize
                  your application to open.
                  >
                  Ron, King of Chi
                  >
                  On Aug 13, 6:29 am, Rocky <consult...@ran dalstewart.comw rote:
                  >
                  MyAccess2007fil e fails to open on a machine with the2007Access
                  runtimeversion installed. It comes up with a Security alert message.
                  Is there a security setting in theAccessDataba se that needs to be
                  enabled to run the code and macros?- Hide quoted text -
                  >
                  - Show quoted text -
                  >
                  Thanks Ron. I have opened the properties/security tab and given all
                  users full permission and re-booted the system.
                  Still comes up with the same message.
                  >
                  The security system changed in A2007.
                  You have to determine a Trusted Location (folder) for your accdb.
                  In full version that's done by adding the place to a list underAccess
                  options.Runtime has no office menu button. So you have to add the folder to
                  the registry manually adding a locations key, e.g.:
                  >
                  [HKEY_CURRENT_US ER\Software\Mic rosoft\Office\1 2.0\Access\Secu rity\Trusted
                  Locations\Locat ion1]
                  AllowSubFolders (REG_DWORD) = 1
                  Path (REG_SZ) "C:\MyTrustedDa tabaseFolderNo1 "
                  >
                  [HKEY_CURRENT_US ER\Software\Mic rosoft\Office\1 2.0\Access\Secu rity\Trusted
                  Locations\Locat ion2]
                  AllowSubFolders (REG_DWORD) = 1
                  Path (REG_SZ) "C:\MyTrustedDa tabaseFolderNo2 "
                  >
                  Ciao, Sascha- Hide quoted text -
                  >
                  - Show quoted text -
                  Thanks. It worked

                  I also had to include an autoexec makro to open the switchboard at
                  startup. Access 2007 does not seem to have a simple way of automating
                  startup, as dis Access 2002/3

                    Comment

                    • superspd@gmail.com
                      #6
                      Re: Access 2007 Runtime Security Issue

                      On Aug 15, 4:52 am, Rocky <consult...@ran dalstewart.comw rote:
                      On Aug 14, 11:15 am, "Sascha Trowitzsch" <n...@moss-soft.dewrote:
                      >
                      Hi Rocky,
                      >
                      "Rocky" <consult...@ran dalstewart.coms chrieb im Newsbeitragnews :1187076029.197 592.71310@q4g20 00prc.googlegro ups.com...
                      >
                      On Aug 13, 4:51 pm, King Ron <KingRonPoindex ...@covad.netwr ote:
                      >As a security measure, by default Windows will not allow databases
                      >created on external and untrusted machines to automatically open. It's
                      >probable that you need to authorize theAccessapplic ation.
                      >
                      >In Windows explorer, Right-click on the .mdb or .mde file and select
                      >'Properties' . On the General tab there should be a button to authorize
                      >your application to open.
                      >
                      >Ron, King of Chi
                      >
                      >On Aug 13, 6:29 am, Rocky <consult...@ran dalstewart.comw rote:
                      >
                      MyAccess2007fil e fails to open on a machine with the2007Access
                      >runtimeversi on installed. It comes up with a Security alert message.
                      Is there a security setting in theAccessDataba se that needs to be
                      enabled to run the code and macros?- Hide quoted text -
                      >
                      >- Show quoted text -
                      >
                      Thanks Ron. I have opened the properties/security tab and given all
                      users full permission and re-booted the system.
                      Still comes up with the same message.
                      >
                      The security system changed in A2007.
                      You have to determine a Trusted Location (folder) for your accdb.
                      In full version that's done by adding the place to a list underAccess
                      options.Runtime has no office menu button. So you have to add the folder to
                      the registry manually adding a locations key, e.g.:
                      >
                      [HKEY_CURRENT_US ER\Software\Mic rosoft\Office\1 2.0\Access\Secu rity\Trusted
                      Locations\Locat ion1]
                      AllowSubFolders (REG_DWORD) = 1
                      Path (REG_SZ) "C:\MyTrustedDa tabaseFolderNo1 "
                      >
                      [HKEY_CURRENT_US ER\Software\Mic rosoft\Office\1 2.0\Access\Secu rity\Trusted
                      Locations\Locat ion2]
                      AllowSubFolders (REG_DWORD) = 1
                      Path (REG_SZ) "C:\MyTrustedDa tabaseFolderNo2 "
                      >
                      Ciao, Sascha- Hide quoted text -
                      >
                      - Show quoted text -
                      >
                      Thanks. It worked
                      >
                      I also had to include an autoexec makro to open the switchboard at
                      startup. Access 2007 does not seem to have a simple way of automating
                      startup, as dis Access 2002/3
                      In Access 2007, open up the program, click on the office button. At
                      the bottom is a button for acces options. Pic current or this data
                      base. Select the startup screen.

                        Comment

                        Previous template Next
                        Working...