ADO.NET远程访问Access数据库的连接字符串

时间:2022-06-19 07:34:35

private string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Work\文件名\emmahome.mdb;Persist Security Info=True";//访问本地

 private string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; User ID=Administrator; password=HelloWorld!;Data Source=\\192.168.0.170\D:\ACCESS\#emmahome.mdb;";//访问远程 Jet OLEDB:Database Password=meimima,.

//private string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\192.168.0.250\c$\Access\#emmahome.mdb;Persist Security Info=false";//访问远程  注意目前没有输入 Uaer ID=Admin; password=112233;

Jet OLEDB:Database Password=111222;//这是Access数据库的密码