ms access 2010 runtime doesn't work with accde files

Question

I have an Access 2010 app that works fin in the full version of Access. However, when I compile an accde and have the end user install the runtime there are no forms, everything is blank. I tried this on several computers and it's the same. When I simulate the runtime environment locally by using the /runtime flag it runs fine. What's going on? Aren't accde files supposed to work with the runtime alone?

Thank you

Billy

Answer 1

You will need to go to this key and add a Reg_DWORD called “AllowNetworkLocations” and give it a value of 1.

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations

No, I would not expect your end users to do this.  If you are using runtime and need to setup trusted locations, then you will need to find a way to push out these regkeys to each of your users.

Best Regards,

Nathan O.

Microsoft Online Community Support

Answer 2

Hi Nathan. What's the other key? It is on a network share. So am i supposed to tell all end users to edit their registry?? :-o

Answer 3

When using runtime you will need to create the trusted location within the registry.  The following link shows the path for Access 2007 Runtime. 

http://www.accessjunkie.com/Pages/faq_33.aspx

If you are using Access 2010 runtime, the path will be similar but instead of 12.0 you will use 14.0:

[HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Access\Security\Trusted Locations\Location0]

AllowSubFolders (REG_DWORD) = 1

Path (REG_SZ) "C:<path to database here>"

This also assumes the file is on the local machine.  If it is on a network share then you will also need to adjust another key.

Best Regards,

Nathan O.

Microsoft Online Community Support

Answer 4

Hi thanks for your reply.

1. I do have a startup form. I set it up under file->options->current database->display form
2. I cannot setup trusted locations in the end user's PC. All options under the runtime are grayed out
3. No error just a blank screen in the runtime
4. There is a popup asking if you are sure you want to trust the source of the file. I click open and then get the blank screen

Answer 5

Hi Billy,

A few questions I have are:

+>Does your database have a startup form?  If so, how are you opening this startup form?  Did you set it within the Access options, using an Autoexec macro, or VBA code?

+>Do you have a trusted location setup for this database within your Access Runtime environment?  If you don’t this will block any code and unsafe macros from running, which could be causing your problem?

+>Are you receiving any errors?

+>What happens if you open the ACCDB file within the Access Runtime environment on the problematic machines?

Best Regards,

Nathan O.

Microsoft Online Community Support