I am tryin to create a login for a VB Studio 2005 program for an Access database that resides locally (I do not want a web based login) It needs to check the username and password and if validated allow the user to go the VB form for the database. Anyone know how to do this?

first create ur database and connect to it using the code below

"Provider=Microsoft.Jet.OLEDB.4.0;User ID= Gbenga;Password= minestone;Data Source= c:\mydata.mdb Mode=ReadWrite;Jet OLEDB:System database= myworkgroup.mdw Jet OLEDB:Engine Type=5"

where User ID and Password should be the name and password of the owner of the database
system database should be the name of the workgroup file which contains the database information.

After you connecting to the database design a small form for login where you can add, remove or delete users and new users can create their name and password and existing users can just login.