Access 2003 + 2010

Hi NG

I am developing small apps in Access...
I got the Access Runtime module. I use it for distribute my apps...

The problem is, when I start the Runtime installation(on another PC)
a securitybox appears...

I want to get rid of that securitybox...???

I study the internet, and i think it says, that I need a certificate...

If I need that certificate, where can I get that...???

Regards
Bjarne
"Every day new surprises"

You can get certificates from Thawte:

http://www.thawte.com/code-signing/

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access Solutions", published by Wiley


"bsn" <bsnSNABELAoncableDOTdk> wrote

Thanks for answer...

And it removes the securitybox that popup when starting Access Runtime
module...???

Bjarne


"Arvin Meyer" <arvinm (AT) invalid (DOT) org> skrev i en meddelelse
news:MLednQyoefmJ3yHRnZ2dnUVZ_gudnZ2d (AT) earthlink (DOT) com...

?A real simple way to get rid of security prompts for the 2003 runtime is to
set macro secuirty = low.

The reg keys for 2003 runtime are:
Simply add the following keys to your runtime packing (the package wizard
does have provision for adding regs keys).

ROOT:Local Machine
Key: SOFTWARE\Microsoft\Jet\4.0\Engines
Name:SandBoxMode
Value:#00000002

ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security
Name:Level
Value:#00000001

For 2007 runtime:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security
\Trusted Locations\
Location(x)
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyDatabaseFolder\"

or

Root: HKCU;Subkey:
"Software\Microsoft\Office\12.0\Access\Security";V alueType: dword;
ValueName: "VBAWarnings"; ValueData: "1"

I do not have 2010 keys. However, it is generally the most trouble free
setting, and it does remove all security prompts. For 2007, and 2010,
another way is to add trusted locations to the registry (as above 2007
shows).

So, trusted location, or macro security = low is a good choice in place of
security certifies.

I have not done testing with 2010 as per above settings, but I am assuming
they will work as above if changed for 2010.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

Thanks a lot...
A good solution if it can work...
Ill look into it, and maybee come back if trouble appears...
Bjarne


"Albert D. Kallal" <PleaseNOOOsPAMmkallal (AT) msn (DOT) com> skrev i en meddelelse
news:cZ0vo.3005$TJ7.1057 (AT) newsfe11 (DOT) iad...
?A real simple way to get rid of security prompts for the 2003 runtime is to
set macro secuirty = low.

The reg keys for 2003 runtime are:
Simply add the following keys to your runtime packing (the package wizard
does have provision for adding regs keys).

ROOT:Local Machine
Key: SOFTWARE\Microsoft\Jet\4.0\Engines
Name:SandBoxMode
Value:#00000002

ROOT:Local Machine
Key: Software\Microsoft\Office\11.0\Access\Security
Name:Level
Value:#00000001

For 2007 runtime:

HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security
\Trusted Locations\
Location(x)
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\MyDatabaseFolder\"

or

Root: HKCU;Subkey:
"Software\Microsoft\Office\12.0\Access\Security";V alueType: dword;
ValueName: "VBAWarnings"; ValueData: "1"

I do not have 2010 keys. However, it is generally the most trouble free
setting, and it does remove all security prompts. For 2007, and 2010,
another way is to add trusted locations to the registry (as above 2007
shows).

So, trusted location, or macro security = low is a good choice in place of
security certifies.

I have not done testing with 2010 as per above settings, but I am assuming
they will work as above if changed for 2010.

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
Pleasenospam_kallal (AT) msn (DOT) com

On Mon, 18 Oct 2010 13:11:05 -0600, "Albert D. Kallal"
<PleaseNOOOsPAMmkallal (AT) msn (DOT) com> wrote:

I'd suggest not using Location(s) as the registry key. Instead use
your application name. Otherwise you might overwrite a user or other
app created Location(x).

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

On Mon, 18 Oct 2010 08:48:30 -0400, "Arvin Meyer" <arvinm (AT) invalid (DOT) org>
wrote:

Cheapest code signing I found was
https://secure.ksoftware.net/code_signing.html

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

"Tony Toews" <ttoews (AT) telusplanet (DOT) net> skrev i en meddelelse
news:db4sb6pt84eo9742dnq93ebnshvubt7skp (AT) 4ax (DOT) com...
Thanks for answer...
You mean
Path (REG_SZ) "C:\MyDatabaseFolder\MyDatabase.mdb"
???

Bjarne

On Thu, 21 Oct 2010 11:59:48 +0200, "ngs" <bsnbsn_SNABELA_ofir.dk>
wrote:

That might work but I was thinking in terms of
"My excellent application" or "HR database" or "Time keeping database"
Basically whatever you would put in the FE database Startup Options
Application Title.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/

On Oct 22, 8:39*am, Tony Toews <tto... (AT) telusplanet (DOT) net> wrote:
Another approach is
1. create a standard folder structure for your application,
2. in your developer version (full version of Access) set the Trusted
Locations using the Access Options>Trust Center>Trust Center
Settings>Trusted Locations.
Add you folder to the trusted locations list.
3. Using REGEDIT export the [HKEY_CURRENT_USER\Software\Microsoft
\Office\12.0\Access\Security] reg settings. This will create a .REG
The REG key will look something like:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security]
"VBAWarnings"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security
\Trusted Locations]
"AllowNetworkLocations"=dword:00000001

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security
\Trusted Locations\Location0]
"Path"="D:\\APPS\\"
"AllowSubfolders"=dword:00000001
"Description"=""
"Date"="17/04/2009 2:00 PM"

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\A ccess\Security
\Trusted Locations\Location2]
"Path"="C:\\Program Files\\Microsoft Office\\Office12\\ACCWIZ\\"
"Description"="Access default location: Wizard Databases"

You can have multiple LOCATIONS, or you can put all you applications
under one folder (D:\APPS) and all subfolders will also be included in
the single entry
4. You can then get the user (or a batch file) to run the .REG file
(just double click)

I use this in a government organisation with a strick lockdown SOE
using runtimes (2007) and it works very well.

Hope this helps

Jan