Show Bid Request VB.Net Code For Simple Access DB Statements Bid Request Id: 26986 Bookmark in my 'To Do' list Posted by: rsanderson (0 ratings) Non-action Ratio: Bad - 71.43% Buyer Security Verifications: Unverified Approved on: Sep 10, 2002 1:14:29 AM EDT Bidding Closes: Sep 13, 2002 1:32:13 AM EDT Viewed (by coders): 313 times Deadline: 9/20/2002 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Database, Language Specific, Visual Basic .Net Enter chat room for this bid request (0 active users at Sep 23, 2003 3:15:50 PM EDT) Description: 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. Deliverables: 1) Complete and fully-functional working program(s) in source code format. 2) Complete ownership and distribution copyrights to all work purchased. Platform: VB.NET Must be 100% finished and received by buyer on: Sep 20, 2002 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Additional Files: This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! Jeffery Crooks (13 ratings) in Virginia Beach, Virginia United States Bid id: 304,762   $20 (USD) Sep 10, 2002 4:42:42 AM EDT  9.76 (Excellent)     Hello. Here you go. If it's useable and a reasonable bid, please accept my bid. Use it in good faith. Jeffery Crooks Virginia Beach, VA Attached File           There are 3 private replies to/from Jeffery Crooks. Click here to view them.