I have a database which is intented to have only a small number of users,
each with unique user IDs
I can set up file security in Access 2003 and get users to log in
indivually, but would rather have them login automatically based on their
network login details.
All users would be classed as "non-admin" users unless their user IDs
matched a limited (hard-coded) list. I essentially want auto-login to Access
2003 pulling user-ID details from network login. Security is then controlled
from this point.

Is this possible to do?

Rich

Rich wrote:
> I have a database which is intented to have only a small number of
> users, each with unique user IDs
> I can set up file security in Access 2003 and get users to log in
> indivually, but would rather have them login automatically based on
> their network login details.
> All users would be classed as "non-admin" users unless their user IDs
> matched a limited (hard-coded) list. I essentially want auto-login
> to Access 2003 pulling user-ID details from network login. Security
> is then controlled from this point.
>
> Is this possible to do?
>
> Rich

It is not possible for Access User Level Security to automatically make use of
the user's Windows credentials as the Access login. It IS possible for you to
retrieve the Windows login name and programmatically apply a home-grown sort of
security, but it will not be as robust as user level security.

If you have concerns about "real" security meaning there is the possibility of
users actually trying to defeat it then user level security is not that great
either. There are utilities on the web one can acquire that can get around it.
If you mostly want to guide cooperative users then the home-grown method should
be fine and in that case you don't need user level security at all. Just use
Environ() or the API method to grab the Windows login name at startup.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com