Access 2007 Runtime questions

  • Thread starter Thread starter George
  • Start date Start date
G

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
 
George said:
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?
Click to expand...

See what Jeff Conrad has at http://accessjunkie.com/faq_33.aspx
2) Shall I convert my database into 2007 version?
Click to expand...

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?
Click to expand...

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.
 
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" έγγÏαψε:
 
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!)


George said:
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.
Click to expand...
Click to expand...
 
Back
Top