Deploying Access 2007 Application w/ Runtime

[kagard]

Greetings:

I have developed an application (originally in Access03, migrated to
07) that I need to deploy to a half dozen users who do not have
Access07. I've downloaded the 07 Developer Extensions and Runtime and
created a runtime version of my app. that works on my PC. On a user
PC's it installs, loads the splash screen and sits there.

My research here and at MS indicates that Access has disabled the code
behind forms. As I understand it, the app. has to run from a trusted
location, or have a digital signature attached to it to run. So here
are my questions:

1. How can the users set up a trusted location when they don't have
Access 07?

2. I think I read that a self-signed project won't run on other PCs -
is that correct?

3. Is there any way to avoid paying hundreds of dollars for a 3rd
party digital signature?


I'm so close to being done with this - I'd really appreciate any
insights.

TIA

Keith

 

[boblarson]

This should answer your question:

http://www.thescripts.com/forum/post2752405-4.html


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.

 

[kagard]

Hi Bob:

Thanks for the reply. The suggested solution seems easy:

"
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_USER\Software\Microsoft\Office\12.0\Access\Security
\Trusted
Locations\Location1]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyTrustedDatabaseFolderNo1"
"

I love it, but it seems too simple. Does that mean, if I'm an evil
coder, all I have to do is create a trusted location for my malicious
application in this manner and it will bypass the Trust Center
entirely? If it's that easy to defeat, what's the point?

Keith

 

[Tony Toews [MVP]]

I love it, but it seems too simple. Does that mean, if I'm an evil
coder, all I have to do is create a trusted location for my malicious
application in this manner and it will bypass the Trust Center
entirely? If it's that easy to defeat, what's the point?

I haven't played with that myself. However I would suspect that
registry key can only be updated by an administrator.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Kerry]

I haven't played with that myself. However I would suspect that
registry key can only be updated by an administrator.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

I just tried to create this key on my computer at work, and was able
to. I am not an administrator.

 

[Tony Toews [MVP]]

I just tried to create this key on my computer at work, and was able
to. I am not an administrator.

Oh dear.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[kagard]

Oh dear.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Hi again:

Confirmed. I tried it successfully on one of our student PCs at work.

Keith

 

[kagard]

Oh dear.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

BTW, lets not fix this until my project is delivered, OK?

Keith

 

[kagard]

Oh dear.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

BTW, lets not fix this until my project is delivered, OK?

Keith

 

[Tony Toews [MVP]]

BTW, lets not fix this until my project is delivered, OK?

<guffaw>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/