[dex619]

First of all, no i am not trying to hack a database , i am trying to link to a database, created in MS Access, and have the user log into it, but i still get an error saying

Quote

an unhandled expression of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

here is the code i'm using to input the password and username from a text box

 conn = ("Provider=MICROSOFT.JET.OLEDB.4.0; Data Source= ***path***/data.mdb; User ID='" & txt1.text & "';Password='" & txt2.text & "'")

By the way the database is password protected by access.

[krum110487]

What version of access is it?

[dex619]

krum110487, on 16 Mar, 2009 - 07:13 PM, said:

What version of access is it?

MS Access 2003

[eworm]

Try removing the single quotes (') around your textbox entries? I don't believe you need them in a connection string.

 conn = ("Provider=MICROSOFT.JET.OLEDB.4.0; Data Source= ***path***/data.mdb; User ID=" & txt1.text & ";Password=" & txt2.text)

This post has been edited by eworm: 17 March 2009 - 12:11 PM

[krum110487]

I KNOW IT hahah, after your password add a semicolon!!

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;

http://www.connectio...ings.com/access

[dex619]

thanx m8, by the way i edited your code, and this works

conn = ("Provider=MICROSOFT.JET.OLEDB.4.0; Data Source= ***path***/data.mdb; User ID='" & txt1.text & "'; JET OLEDB: Database Password='" & txt2.text & "';")

This post has been edited by dex619: 17 March 2009 - 07:07 PM