Users in Access 2000

[travismp]

Is there a way in Access 2000 that I can set up a users table? Basic info:

Name
Phone Number
Fax Number

Then every time the database is opened they are prompted for their name?

I have a database that has a Fax Cover Sheet within the DB, when they click the Fax Cover Sheet Form I want their information to automatically be generated into the form based on the information from the original table.

Hope this is clear. Thanks.

Travis

 

[Pat Hartman]

Of course. Create the table. Create a login form that opens when the database opens and prompts people to sign in. The login form can then open your standard form.

PS - "Name" is a poor choice as a column name since it is the name of a VBA property and you will have a great deal of trouble if you ever need to write VBA. Also do not use embedded spaces in your datanames. Although FullName is a possibility, it is far better to use FirstName and LastName because it gives you more flexibility.