I have to retrive,insert and delete information from an access databse during runtime. the problem is that how can i do these things during runtime...
please guide me how to access the database through asp when the database is password protected..
what modification should be done to the present code that i have been using to acess file wen it not password protected....

strConnect = " Provider=Microsoft.Jet.OLEDB.4.0;" & _
            " Data Source = " & Server.MapPath("Security.mdb") &" ;"& _
             " Persist Security Info=True"

if the password is XYZ how the code should be entered...
thnxs

Try adding a password parameter in the connection string. See the help for the correct syntax.

Jim

http://www.connectionstrings.com

Jacob.