尝试从2010年开始向MS添加数据源,密码保护Access数据库,方法是转到Excel -> data -> from Access (在获取外部数据中)-->选择数据库。我使用“遗留加密方法”设置数据库密码(正如在有关此问题的其他问题上提到的那样),但它似乎是数据库锁定问题。在excel中,我将“开放模式”设置为DB_MODE_READ,
using (System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(@"Provider=Microsoft.ACE.OLEDBquery = @"select SUM(SQuantity) AS 'Total' From Sales where Sdate = @datetime";
System.Data.OleDb.OleDbCommandc
Dim Con As OleDb.OleDbConnection = New OleDb.OleDbConnection Dim DBSourceAs String Dim DA As OleDb.OleDbDataAdapter DBProvider = "PROVIDER=Microsoft.ACE.OLEDB.1