>I have developed several applications for my department. In each app I have a table that holds authorized users and level of access(functions within the app they can perform). Many users have access to all the apps and some only one or two. Each app is very different in function example one is a time keeping/scheduling app, another document sign-off app, one is a data submittal app. Anyway, I would like some suggestions on the best way to handle this. Right now if a new employee gets hired I have to add them to each database they will use. I there a way to minimize the data to input?

The way I handle this is to have a single table with users. Key fields include authorization level, and department. Then, the forms table lists what departments (purchasing, sales, accounting, etc.) can access each form.

Most user interaction is done through forms; individual forms don't appear in the main menu, only on the "File | Open" dialog (and in the list of recently used forms).

Most of this is part of the framework I use (Visual Extend); I had to add fields for department to the forms and user tables.

HTH, Hilmar.