User-level Security

[Jan]

I'll try to make this simple...

Is there a way (via code) to have a user log in with a
password and then have that entered username taken by the
code and plugged in as the criteria for a query which will
then only allow the user to see records with a database
that pertain to him?

Anxiously awaiting a response...

 

[Jack MacDonald]

Once you have properly configured the user-level security, you can use
the CurrentUser() function to retrieve the login name of the current
user. It can be used as a query criterion. If you want to prevent the
user from modifying tables directly, you must use so-called Run With
Owner's Permissions queries that (in your case) would return just the
current user's records. It's explained in the Security FAQ. See the
website in my signature for a link.

I'll try to make this simple...

Is there a way (via code) to have a user log in with a
password and then have that entered username taken by the
code and plugged in as the criteria for a query which will
then only allow the user to see records with a database
that pertain to him?

Anxiously awaiting a response...

=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd