Access 2007 Runtime questions

[George]

Dear friends, I have the following questions regarding 2007 Runtime (I have
already downloaded and installed it on a machine having Windows XP + MS
Office PRO 2003), and I want to use Access 2007, for its new features, i.e.
date picker which appears automatically in date fields.:

1) I have copied a database on the a.m. machine (tha database is in 2003
format). Unfortunately it doesnt show my switchboard, due to blocked
macros/trusted locations I believe. How can I set the enable macros and/or
trusted locations in the runtime?

2) Shall I convert my database into 2007 version?

3) Can I use for this particular database the 2007 runtime and not the full
version of 2003 which is already installed?

Thanking you in advance

GeorgeCY

 

[Douglas J. Steele]

Dear friends, I have the following questions regarding 2007 Runtime (I
have
already downloaded and installed it on a machine having Windows XP + MS
Office PRO 2003), and I want to use Access 2007, for its new features,
i.e.
date picker which appears automatically in date fields.:

1) I have copied a database on the a.m. machine (tha database is in 2003
format). Unfortunately it doesnt show my switchboard, due to blocked
macros/trusted locations I believe. How can I set the enable macros
and/or
trusted locations in the runtime?

See what Jeff Conrad has at http://accessjunkie.com/faq_33.aspx

2) Shall I convert my database into 2007 version?

Many of the new features in Access 2007 only work if the database is in the
new ACCDB format.

3) Can I use for this particular database the 2007 runtime and not the
full
version of 2003 which is already installed?

Create a shortcut that includes the location of msaccess.exe for the
runtime, as opposed to just having Windows use whatever application is
associated with the mdb extension.

 

[George]

Thanks Douglas for your valuable help,

Please, could you please tell me how can I make the script or how can I do
it manually (I know how to run the regedi and how to find the path) for:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations\Location0]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\AccessJunkiesRule"

Thanks again

GeorgeCY

Ο χÏήστης "Douglas J. Steele" έγγÏαψε:

 

[Douglas J. Steele]

Since VBA code won't run unless the application is in a Trusted Location,
it's not really something you should be doing from within Access.

One approach is to go into Regedit and create a .REG file for the specific
path, then add that file by calling Regedit in a batch file before launching
the application.

Another approach would be to run VBScript to use the RegWrite method of the
WshShell object, something like

Dim WshShell

Set WshShell = WScript.CreateObject("WScript.Shell")
WshShell.RegWrite _
"HKCU\Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations\Location0]", _
"C:\AccessJunkiesRule"


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Thanks Douglas for your valuable help,

Please, could you please tell me how can I make the script or how can I
do
it manually (I know how to run the regedi and how to find the path) for:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted
Locations\Location0]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\AccessJunkiesRule"

Thanks again

GeorgeCY

? ??????? "Douglas J. Steele" ???????:

See what Jeff Conrad has at http://accessjunkie.com/faq_33.aspx


Many of the new features in Access 2007 only work if the database is in
the
new ACCDB format.


Create a shortcut that includes the location of msaccess.exe for the
runtime, as opposed to just having Windows use whatever application is
associated with the mdb extension.