Access 2007 Runtime questions

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

"George" wrote in message
...
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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(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\A ccess\Security\Trusted
Locations\Location0]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\AccessJunkiesRule"

Thanks again

GeorgeCY

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

"George" wrote in message
...
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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

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\Securi ty\Trusted
Locations\Location0]", _
"C:\AccessJunkiesRule"


--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"George" wrote in message
...
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\A ccess\Security\Trusted
Locations\Location0]
AllowSubFolders (REG_DWORD) = 1
Path (REG_SZ) "C:\AccessJunkiesRule"

Thanks again

GeorgeCY

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

"George" wrote in message
...
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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)