L
LauraB
Hello. We have a database in Access 2000 file format that we have been using
in Access 2003, and we recently upgraded to using Access 2007, although our
database is still in the same old 2000 file format.
There are a couple of things I'd like to do:
1. Get rid of the security warnings when opening the database.
I was thinking about figuring out how to digitally sign the database. In
fact it looked easier to do in Access 2007, but as well it looked like I
could also use the 'put in trusted location feature'. My understanding is
that to do the latter I'd have to upgrade to the 2007 file format.
2. Potentially set up user-level security to the database.
We have been thinking about adding this, but I saw that this feature went
away for 2007. I would guess that if I haven't set this up yet, it wouldn't
be recommended to do this now? Especially since if I wanted it I couldn't
upgrade to the 2007 file format.
Minimally, it would be nice to have some users access the database with no
editing ability (but full access to read any data), and other users with full
admin/editing access. Is there another way to do this besides user-level
security?
Any tips on the easiest way to accomplish these goals, and what file format
to upgrade to is appreciated. There's a steep learning curve for these
security issues for someone who created a database over 5 years ago. Thx.
in Access 2003, and we recently upgraded to using Access 2007, although our
database is still in the same old 2000 file format.
There are a couple of things I'd like to do:
1. Get rid of the security warnings when opening the database.
I was thinking about figuring out how to digitally sign the database. In
fact it looked easier to do in Access 2007, but as well it looked like I
could also use the 'put in trusted location feature'. My understanding is
that to do the latter I'd have to upgrade to the 2007 file format.
2. Potentially set up user-level security to the database.
We have been thinking about adding this, but I saw that this feature went
away for 2007. I would guess that if I haven't set this up yet, it wouldn't
be recommended to do this now? Especially since if I wanted it I couldn't
upgrade to the 2007 file format.
Minimally, it would be nice to have some users access the database with no
editing ability (but full access to read any data), and other users with full
admin/editing access. Is there another way to do this besides user-level
security?
Any tips on the easiest way to accomplish these goals, and what file format
to upgrade to is appreciated. There's a steep learning curve for these
security issues for someone who created a database over 5 years ago. Thx.