connecting acces by using .udl file

Erdinc Kolukisa

hey coders..i want to connect my program with access..To do that i created a database in Access 2007 and saved it as Access 2003 with mdb extension..and i moved it to my project's debug file and i tried to connect it with udl file under debug fiile also...mdb has a password...i dont make a password for the mdb the connection is successfull but when i make a password there it gives error like "the provider had an error while connecting " and something like that
so what is wrong here? and why i can connect to database when i dont have a password

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Erdinc Kolukisa16y ago

connn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:Database Password=1;Data Source=Faturam.mdb");
when i use it like that it works but not in my udl file..i didnt understand the problem..
Felipe Ramos16y ago
Can you share your connection string?

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

You can find the rest here
http://www.connectionstrings.com/access