none
How di I make an Access Database open with Runtime vs MS Access?

    Question

  • I have a MS Access database that is used by my department and until recently only one pc had MS Access loaded on it which was great.

    Now we have new pc's and they added MS Access to another pc but I want to make sure that when the database that is used by our department is opened on that pc that it is opened using MS Access Runtime instead of MS Access.

    What can I do to make sure that the database is only opened using runtime?

    Thanks

    Tuesday, January 11, 2011 2:11 AM

Answers

  • "wdkoseck" wrote in message
    news:bd6f0082-79a1-41a6-b176-bb92906b3c72@communitybridge.codeplex.com...
    >I have a MS Access database that is used by my department and until
    >recently only one pc had MS Access loaded on it which was great.
    >
    > Now we have new pc's and they added MS Access to another pc but I want to
    > make sure that when the database that is used by our department is opened
    > on that pc that it is opened using MS Access Runtime instead of MS Access.
    >
    > What can I do to make sure that the database is only opened using runtime?
    >
     
    Does it really have to be opened using the runtime (which must then also be
    installed on the user's PC), or is it enough to have it opened in runtime
    *mode* (so none of the built-in menus appear)?  If the latter, then you can
    have the database opened by a shortcut that specifies the /runtime
    command-line switch;  if it really has to be the run-time, then you need to
    use a shortcut that specifically provides the path to the run-time module as
    the executable.
     
    Either way, you have to ensure that they only open the database by means of
    a shortcut that specifies the Access executable for its target and provides
    the path and name of the database as a command-line argument.  You mustn't
    allow them to just double-click on the database file.
     
     

    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html
    • Marked as answer by Bessie Zhao Monday, January 17, 2011 11:08 AM
    Tuesday, January 11, 2011 3:43 AM

All replies

  • "wdkoseck" wrote in message
    news:bd6f0082-79a1-41a6-b176-bb92906b3c72@communitybridge.codeplex.com...
    >I have a MS Access database that is used by my department and until
    >recently only one pc had MS Access loaded on it which was great.
    >
    > Now we have new pc's and they added MS Access to another pc but I want to
    > make sure that when the database that is used by our department is opened
    > on that pc that it is opened using MS Access Runtime instead of MS Access.
    >
    > What can I do to make sure that the database is only opened using runtime?
    >
     
    Does it really have to be opened using the runtime (which must then also be
    installed on the user's PC), or is it enough to have it opened in runtime
    *mode* (so none of the built-in menus appear)?  If the latter, then you can
    have the database opened by a shortcut that specifies the /runtime
    command-line switch;  if it really has to be the run-time, then you need to
    use a shortcut that specifically provides the path to the run-time module as
    the executable.
     
    Either way, you have to ensure that they only open the database by means of
    a shortcut that specifies the Access executable for its target and provides
    the path and name of the database as a command-line argument.  You mustn't
    allow them to just double-click on the database file.
     
     

    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html
    • Marked as answer by Bessie Zhao Monday, January 17, 2011 11:08 AM
    Tuesday, January 11, 2011 3:43 AM
  • Thank you for your help - using the /runtime switch might just do the job. I added it to the shortcut and that looks much better.

     

    One additional question - When I open the database I always get a 'Security Notice" about the content comming from a Trusted source - how can I eliminate this error message?

    I just had Access 2007 installed and I am trying to get used to this product as it is a different look and feel from the 2003 or earlier versions that I have used in the past.

    Thanks

    Tuesday, January 11, 2011 3:57 AM
  • Look up "Trusted Location" in the help file. Set it, and the prompt will go away.

     


    -Tom. Microsoft Access MVP
    Tuesday, January 11, 2011 4:09 AM
  • "wdkoseck" wrote in message
    news:ebf56869-2a93-4c9a-a0d1-11d98c59c0a8@communitybridge.codeplex.com...
    >
    > One additional question - When I open the database I always get a
    > 'Security Notice" about the content comming from a Trusted source - how
    > can I eliminate this error message?
    >
    Normally what I recommend is that you use the Trust Center to designate the
    folder where the database resides as a Trusted Location.  That's available,
    if I recall correctly, via the "Office" button -> Options... -> Trust
    Center -> Trust Center Settings.  Tell Access that's a trusted location, and
    it won't bug you any more about the potential danger of code and macros.
     
     

    Dirk Goldgar, MS Access MVP
    Access tips: www.datagnostics.com/tips.html
    Tuesday, January 11, 2011 4:16 AM
  • Thanks - that works on the pc with MS Access loaded on it but not on the pc's without MS Access loaded.

    Is there a way to use the trust center to eliminate this message on the pc's without MS Access loaded?

    Tuesday, January 11, 2011 4:32 AM
  • Hi wdkoseck
     
    >= A2007 in ACCDB format? The easiest way is to rename the ACCDB or ACCDE to ACCDR extension. Then Access will - even if started in the full version - behave exactly as the runtime of Access. If you do this you don't have to bother about Access full or runtime isntalled, it will always work as runtime.
     
    Henry

    I have a MS Access database that is used by my department and until recently only one pc had MS Access loaded on it which was great.

    Now we have new pc's and they added MS Access to another pc but I want to make sure that when the database that is used by our department is opened on that pc that it is opened using MS Access Runtime instead of MS Access.

    What can I do to make sure that the database is only opened using runtime?

    Thanks

    Tuesday, January 11, 2011 5:33 AM
  • Runtimes cannot create Trusted Locations so you must do it with a registry file. One way to do that...

    'Start of Code  (Do NOT copy this line)

    Windows Registry Editor Version 5.00

    [HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\MyApp]
    "Path"="C:\\MyApp"
    "AllowSubfolders"=dword:00000001
    "Description"="My trusted location"

    'End of Code  (Do NOT copy this line)

    Name the above something like *TrustMe.reg* and have your Users double-click.  Make to change MyApp to the location of your database.


    --
    Gina Whipp
    Microsoft MVP (Access)

    Please post all replies to the forum where everyone can benefit.
    Tuesday, January 11, 2011 6:38 AM