Access2000: Securing databases

[Arvi Laanemets]

Hi

Somehow MS Access Help about subject is vague - I feel half the needed
information is left out.

I'll have several Access applications (two at moment), which will be a
related databases system, i.e. some of tables in one application will serve
as source data for another one. Later I'll split all projects to front- and
back-end, and probably there will be several variants of front-ends. At
moment I'm looking for a way to secure both applications (or have I to split
them before?). The result of securing must:

1. ... allow multi-user access to both (at moment) applications (2-3 users
max);
2. ... allow only for user Autor the access to Database window and the
Design View for forms, reports, etc.;
3. ... allow only for user Autor to add new users with administrative
rights;
4. ... allow user Administraator to add new users with user rights;
5. ... allow users with user rights only open the app in form view, add,
edit and delete data in forms, and run queries and reports called from user
interface.

What I did:
I created a new workgroup information file, then switched back to original
one, and copied newly created mdw-file to applications folder;
I created a shortcut to start one app using new mdw-file;
(I think I have to join my apps to this new mdw-file somehow, but Workgroup
Administrator allows this for Access as whole only - which clearly is not an
option for me. I want that only those apps use this mdw, and only this
one!);
I created new users AuthorX (users, admins) AdministratorX (users, admins)
and UserX (users);
I removed user Admin from admins group, and removed all permissions for this
user (I can't rename or delete it);
I set AuthorX as owner for all objects in app (except Database, where this
wasn't allowed);
I set for user AuthorX administrator rights for all objects, and removed
those rights from user Admin;
I set for users AdministratorX and UserX for all object the right Open/Run
only.

At moment I can start app without shortcut, bypassing mdw-file entirely (how
to join?);
And with any user I log in when starting through shortcut, I can switch to
Design View, or access allSecurity options from Tools menu - all security
settings I estabilished have no effect at all.

I had a secured app some years ago - with Acess97, but I remember little
from it, and anyway I have a feeling there are a lot of differences with
Access2000. Can someone here give me some advice, or point to some web
source with more detailed istructions?


Thanks in advance!

 

[Daniel]

Arvi,

Take a look at http://support.microsoft.com/?id=207793 it is a step by step
of what you have to do. Take the time to go through it completly.

--
Hole this helps,

Daniel Pineault

 

[Tom Wickerath]

Hi Arvi,

To add some to Daniel's advice, take a look at Lynn Trapp's page, especially
"The 10 Steps Summarized", available here:

http://www.ltcomputerdesigns.com/Security.htm


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

Arvi,

Take a look at http://support.microsoft.com/?id=207793 it is a step by step
of what you have to do. Take the time to go through it completly.