Dear All,
I had encountered problem when I set a password in the Access database. It throws an exception.
The connection string that I used is
conn.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;" +
"User Id=;Password=123;" +
@"Data source= C:\\abc\\Login.mdb";
But when I removed the database password, it was able to connect.
The database is situated in c:\abc\Login.mdb.
Thanks