Creating User Ids

[Sawz]

Hey all, This is my first time posting on this site. I have been browsing the forums for a couple days now and have found a lot of useful info. One thing I haven't been able to find howver is a way to create user logins. I am pretty sure that I need to create a table of users, login id, first name, last name, email address, password. My question is how do I force a screen to open up when they try to go in my application that verifies their user id and password from the table before it allows them into my main data entry form. The reason for this is that I want to be able to know who edits what records from the form and what date and time they do it. Thanks for any help given and if you need more info please ask.

 

[Norris68]

I have a table of users, including their NT login name. I then find out their login name when the database starts up (plenty of source code on the web) to identify the user. No need for passwords, as any user not in the table is kicked out immediately.

You will need to create an authentication form that automatically loads on startup (Tools -> Startup). Once the user is authenticated you can then open up the menu form before closing the authentication form.

 

[cmmrfrds]

The simplest is to use NT Authentication for your users on sql server. In each table where I want to track changes, I create a field called userid and default it to suser_sname() and the change date field to getdate(). This tracks the insert. Then, add a trigger to catch the updates.