VB.NET Functions needed to perform three simple statements against an Access database: 1) Insert User into Users Table Function Parameters: Username String, Password String, Groups String Inserts Username, password, groupnames columns from paramters as well as the Active Column as True. Returns True/False if the insert worked or not. 2) Update Password Function Function Parameters: UserName, OldPassword, New Password (All Strings) Compares the Old Password to the New Password for the given username. If they match, it updates the password for that user. Function Returns True/False depending upon a successful update. 3) Delete User Function Parameters: UserName String Deletes the specified user account. Returns True/False if it was found/deleted. All Functions need to open the database connection through a connection string in the code. (Constant value ok in the code for connection string, just need to be able to change the path in the connection string to the location on our HD and the code should work.) No project database connections. Functions must dim a database object, open it, do its stuff and close the connection. Pretty simple actually. Appropriate SQL Statements to be implemented in the VB.NET Code. Database is attached. Developer is only concerned about working with the users table. Value commonly passed in as the GroupNames column will be: ,Vendors, Working Deliverable Completed / Delivered by Sept 20, 2002.
1) Complete and fully-functional working program(s) in source code format. 2) Complete ownership and distribution copyrights to all work purchased.