none
Start *.accdr RRS feed

  • Question

  • Hello,

    I develop my app in the adddb format of course, but want deploy it in the accdr format. For the first test I only have rename the extension.When I double-click on this file the main window of access open and a dialog box where I can only "Stop Macro" with a button. The I get a run-time error and the app stops. 

    What can I do ?

    Thank you.

    Andreas Weichert

    Monday, August 28, 2017 8:58 AM

Answers

  • Did you create a Trusted Location for the front-end of your database?

    Does your database compile without errors?

    Why accdr? accdr is for runtime mode.  I'd normally recommend converting your db to a locked down accde.

    Can you post a screenshot of the message you are referring to?


    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net



    Monday, August 28, 2017 10:44 AM

All replies

  • Did you create a Trusted Location for the front-end of your database?

    Does your database compile without errors?

    Why accdr? accdr is for runtime mode.  I'd normally recommend converting your db to a locked down accde.

    Can you post a screenshot of the message you are referring to?


    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net



    Monday, August 28, 2017 10:44 AM
  • Hi Andreas,

    As Daniel suggested, you'll need to place the file in a Trusted folder, or Enable its content when you open it up.

    Cheers!

    Monday, August 28, 2017 4:10 PM
  • Thank you all for your helpful answers.

    I have solved much now:

    First tried to generate a accde. This did not work because I had a compiler error (thank you for the hint).

    Now I works but I get always the security question. Then I added the path of the accde to the trusted location with my Access program and I works without question now.

    The only problem is: How can I configure trusted locations without installed access. Where can I configure it in Windows for Access ?  (Trusted location seems specific for every office application.)

    --------------------------

    For the sake of completeness what is the accdr extention ? I found the information that the renaming of a accdb to a accdr will cause the starting with only the runtime ???? For what is this extention ?

    Tuesday, August 29, 2017 3:10 PM
  • Thank you all for your helpful answers.

    I have solved much now:

    First tried to generate a accde. This did not work because I had a compiler error (thank you for the hint).

    Now I works but I get always the security question. Then I added the path of the accde to the trusted location with my Access program and I works without question now.

    The only problem is: How can I configure trusted locations without installed access. Where can I configure it in Windows for Access ?  (Trusted location seems specific for every office application.)

    --------------------------

    For the sake of completeness what is the accdr extention ? I found the information that the renaming of a accdb to a accdr will cause the starting with only the runtime ???? For what is this extention ?

    As to the accdr extention, it is meant to be a testing tool to be used by the developer so he can see what his application will look like and how it will act if a user does not have the full version of Access installed but only has the free runtime version. It was never meant to be used as a way to secure the database.

    We've seen many amateur developers give accdr files to their users, thinking this was a way to secure their database. All any user has to do is change the extension back to accdb and he has free rein with access to the tables, design changes, etc.


    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, August 29, 2017 3:21 PM
  • With the runtime you have to use a VBScript or something similar to create the necessary registry entry to create the trusted location for your database.

    Daniel Pineault, 2010-2017 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net

    Tuesday, August 29, 2017 3:30 PM
  • Hi,

    Here's a link to Gunter's website listing all the registry locations, and you can also download an application to do the job for you.

    Hope it helps...

    Tuesday, August 29, 2017 4:15 PM