security in access 2007

[Guest]

Being completely new to access I need some help with the following.
Is it considered good/common practice to purchase third party digital
certificates for security purposes e.g. to get rid of the security message
bar when someone opens up a database ? or do most people get by without this.
The reason i'm asking is that having coughed up a lot of money for access I
wouldn't want to have to shell out what looks like quite a bit of extra money
per year.
My idea is to be able to distribute a small database, for free, to various
users via the internet, for a charity that I help with, so i'd like any
further expense to be kept to a minimum. As I understand it, the forthcoming
access 2007 runtime will be released for free so I will be able to use that
with most of the users. (who probably won't have or need the full version of
access.)
Will I be able to set things up so that users can run the database without
the security message appearing every time the database is opened or is this
something everyone just has to get used to?

 

[Arvin Meyer [MVP]]

User level security still works in Access 2007, but only in an MDB, not in
the new file format. Also the security wizard is gone, so you'll need to set
it up manually. You may find it easier to set it all up in an earlier
version, then upsize it to Access 2007, keeping the earlier format. You may
have a problem with using the runtime though. You will not be able to make
changes to anything in a runtime, so you'll need to use and earlier version,
then rebuild the runtime with each change.

 

[Guest]

Thanks Arvin.
I actually hung back for a while to wait for Access 2007 as not having used
access before, I thought it might be easier to start with the newest version.
(I hadn't realised at the time that normally the runtime and development
extentions etc were not free- so thank god for small mercies)
Looking at the information on-site it looks like the extentions may have
some mechanism for dealing with my problem. Does anyone know if this might be
true?
I now know that you can place trusted databases in a "safe" folder on your
PC but how would I go about getting someone using the runtime to set this up

 

[Arvin Meyer [MVP]]

On a Vista machine, you will need to install as an admin. You can also
create the trusted folder while you are doing the installation. The new
runtime creation utilities are not available yet, and I have not worked with
any admins doing unattended installs. I'd keep up with SageKey tools to see
when they'll have install scripts available.

http://www.sagekey.com/access_2007.aspx

 

[Guest]

Thanks again Alvin.
I'll do that.

On a Vista machine, you will need to install as an admin. You can also
create the trusted folder while you are doing the installation. The new
runtime creation utilities are not available yet, and I have not worked with
any admins doing unattended installs. I'd keep up with SageKey tools to see
when they'll have install scripts available.

http://www.sagekey.com/access_2007.aspx
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com