Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Access 2007 Runtime Followup

  
   Windows Help (Home) -> Microsoft Access RSS
Next:  Generating Serialized Numbers  
Author Message
David W. Fenton

External


Since: Dec 5, 2008
Posts: 37



(Msg. 1) Posted: Sun Dec 21, 2008 6:25 pm
Post subject: Access 2007 Runtime Followup
Archived from groups: microsoft>public>access (more info?)
1. You don't need A2K7 installed to be able to run an MDB created
with A2K3 with the runtime. You just run it.

2. You *do* need A2K7 installed to use the Developer Extensions.

I couldn't figure out how the extensions are actually implemented.
All I could see was a DLL and tried registering it in A2K3, in the
hope that it would run from there, but it didn't.

So, I now know that I can use the runtime for providing
quick-and-dirty access to an Access app, but it's very unattractive.
If that doesn't matter, it's useful. If appearance matters, then
it's not going to work.

For the kiosk app, appearance obviously matters, so I'm going to
have to acquire A2K7 to make it look like an A2K7 app. I hate the
default blue theme, which looks like a cheap web page template, so
I'm going to change that. I did consider just changing the design of
the A2K3 app to look more consistent with the A2K7 look (such as
using powder blue form backgrounds), but really, it's not worth the
work.

I seem to recall that Allen Browne had something on his website
about how to make an MDB look decent in A2K7, but when I Google all
I come up with is the What's New in A2K7 link. Can anyone provide
me a pointer on that?

 >> Stay informed about: Access 2007 Runtime Followup 
Back to top
Login to vote
Albert D. Kallal

External


Since: Dec 4, 2008
Posts: 22



(Msg. 2) Posted: Sun Dec 21, 2008 6:35 pm
Post subject: Re: Access 2007 Runtime Followup
Archived from groups: per prev. post (more info?)
You can place the following line of code in your startup:

DoCmd.ShowToolbar "Ribbon", acToolbarNo

All of the ribbon and nav pane gets hidden when you do the above.

And, you could disable themes...

Application.SetOption "Themed Form Controls", False

 >> Stay informed about: Access 2007 Runtime Followup 
Back to top
Login to vote
David W. Fenton

External


Since: Dec 5, 2008
Posts: 37



(Msg. 3) Posted: Mon Dec 22, 2008 11:25 pm
Post subject: Re: Access 2007 Runtime Followup
Archived from groups: per prev. post (more info?)
"Albert D. Kallal" wrote in

> You can place the following line of code in your startup:
>
> DoCmd.ShowToolbar "Ribbon", acToolbarNo
>
> All of the ribbon and nav pane gets hidden when you do the above.
>
> And, you could disable themes...
>
> Application.SetOption "Themed Form Controls", False

Oh, good. That takes care of about half the things that annoyed me.
The color is still an issue and I don't know what I'll do for
certain.

The other thing is the security warning -- I certainly don't want
that on a kiosk app.
 >> Stay informed about: Access 2007 Runtime Followup 
Back to top
Login to vote
Albert D. Kallal

External


Since: Dec 4, 2008
Posts: 22



(Msg. 4) Posted: Tue Dec 23, 2008 7:01 am
Post subject: Re: Access 2007 Runtime Followup
Archived from groups: per prev. post (more info?)
"David W. Fenton" wrote in message
>
> The other thing is the security warning -- I certainly don't want
> that on a kiosk app.

If you set the following reg key (sets macro = low). Then simply copying any
mdb/accdb to that target box should launch/run without a problem.

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

You can also use/add a trusted location (I not tried the below yet).

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

The package wizard for 2007 does let you set reg keys, but I don't bother
with it since no can figure out how to use that installer for upgrading
front ends. I just use the free inno installer. You can Google for inno, and
it great for deploying new front ends. A sample "front end" install script
is included after my sig in this post...
 >> Stay informed about: Access 2007 Runtime Followup 
Back to top
Login to vote
David W. Fenton

External


Since: Dec 5, 2008
Posts: 37



(Msg. 5) Posted: Tue Dec 23, 2008 6:25 pm
Post subject: Re: Access 2007 Runtime Followup
Archived from groups: per prev. post (more info?)
"Albert D. Kallal" wrote in

> "David W. Fenton" wrote in message
>>
>> The other thing is the security warning -- I certainly don't want
>> that on a kiosk app.
>
> If you set the following reg key (sets macro = low). Then simply
> copying any mdb/accdb to that target box should launch/run without
> a problem.
>
> Root: HKCU;Subkey:
> "Software\Microsoft\Office\12.0\Access\Security";ValueType: dword;
> ValueName: "VBAWarnings"; ValueData: "1"
>
> You can also use/add a trusted location (I not tried the below
> yet).
>
> HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security
> \Trusted Locations\
> Location(x)
> AllowSubFolders (REG_DWORD) = 1
> Path (REG_SZ) "C:\MyDatabaseFolder\"
>
> The package wizard for 2007 does let you set reg keys, but I don't
> bother with it since no can figure out how to use that installer
> for upgrading front ends. I just use the free inno installer. You
> can Google for inno, and it great for deploying new front ends. A
> sample "front end" install script is included after my sig in this
> post...

I figured it would come down to setting registry keys. Since this is
going on a standalone kiosk, with only one machine, I think I'll set
the registry key manually. Or provide the user with a REG file.

I really don't understand why MS thinks it's a good idea to treat
your local hard drive as just as dangerous as the wilds of the
Internet. It contradicts all common sense, and thus leads people to
completely disregard the whole thing and turn off all the security.
 >> Stay informed about: Access 2007 Runtime Followup 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Access 2003 for Runtime App - Just reviewed existing Posts. As of 12/31/08, the best way to do this is???...Develop an Access 2003 MDE..buy Access 2007 (one copy to get the free Acess2007 runtime)...true??..any Bugs?? Also, when is the next Office..13 ??..scheduled? TIA - Bob

Runtime - Microsoft Office Access Security Notice - I have a split ac2007 database that is on a server, two different folders. When I have a user run the frontend from thier PC, they have runtime, they get the Access 2007 Security Warning Box. I think that I have tried everything to stop this from..

Access 2007 - I was just recently updated to Access 2007. I use the database to record our daily payroll detail. I need to get into the form properties to be able to change the date periodically. With the old system (Access 2003) I would just right click on the dat...

Access 2007 -

Faxing using Access 2007 - Access is a great database however, I would like to be able to send out faxes from the database. What are my options to make this happen?
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]