I have databse Crime.mdb at location d:\Ty256\Police-Crime\Crime.mdb.I have table named LogIn which has two fields UserId and Password.I want to create new record in this table by using Insert Query.This values are collected from two text boxes txt1(user name) & txt2(password) and insert them into LogIn table.This should be done on click of Add button.Connection should be opened and closed on click of Add.

This thread is identical to this one

http://p2p.wrox.com/topic.asp?TOPIC_ID=49611

"The one language all programmers understand is profanity."