Hi All,

I would like to create user-specific menus for when the database first opens (including one for the Administrator) all of which hide the "innards" of the database from users.

It would be great if there were a way to track who makes what changes where, too.

Thanks for any help you can each be.
Chuck

Chuck:
There are many ways to do this. This is the basic method.

Create a user table. ID, Password, Level

The level will determine what menu the user gets.

Create login form.

In a module declare a variable:
global gUser as string

In the login assign gUser to User name.

Create a function that returns the user name.

You can use either the variable or the function to update a field you
put in each table called :LastUpdatedBy

I realize this is only an outline.

Good luck

Ira Solomon

Create a form for each level and put command buttons on it to do the
tasks that level person can do.


On Wed, 08 Jun 2005 18:36:31 GMT, "Chuck Insight"
<j.gillham (AT) insightbb (DOT) com> wrote: