Access to the Database

[Martin Hopkins]

Hello,

I currently have a database that can be accessed by trade managers within
work. This control clients details etc.

However due to a reorg and section changes I need to allow only certain
users to access the database.

Can you help with the following:

1. Rather than build another database can I set up a system the when a
certain person logs onto the database that user is presented with a specific
front page, therefore allowing him only access to his areas of
responsiblility.

2. Can I prevent a none authorised user from logging on to the database.
For example if Mr Smith was not allowed to log on he would get a message
saying not authorised and the database would close. have seen this done
using names stored in the database personnel table.

Any help would be helpful.

Martin Hopkins

 

[Keith Wilby]

Hi Martin ...

1. Rather than build another database can I set up a system the when a
certain person logs onto the database that user is presented with a
specific front page, therefore allowing him only access to his areas of
responsiblility.

2. Can I prevent a none authorised user from logging on to the
database. For example if Mr Smith was not allowed to log on he would get a
message saying not authorised and the database would close. have seen
this done using names stored in the database personnel table.

You *could* "roll your own" security by storing names in tables but it could
be very easily broken by someone with only basic knowledge of Access. Both
of your objectives can be achieved by implementing user-level security (ULS)
which, although it can be broken by a determined hacker with some expensive
software, is about as good as it gets for a file-based system, so you'd need
to do a risk assessment.

Having said that, ULS is a complex topic with many pitfalls for the newbie.
If you want to know more, start with the MS FAQ (link on my web site), but
be warned that it contains no filler material and you must implement each
step in the order given and omit nothing. Make regular backups or work on
dummy files until you're confident. Good luck.

Keith.
www.keithwilby.com