tryusing System; using System.Data.OleDb;public class GetTable { public static void Main() { string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb;User ID=admin;"; OleDbConnection conn = new OleDbConnection(ConnectionString); conn.Open(); OleDbCommand cmd = new OleDbCommand(" SELECT Name from MSysObjects WHERE Type = 1 and Name not like \"MSys%\"", conn); OleDbDataReader dr = cmd.ExecuteReader(); int nCount = 0; while (dr.Read()) { Console.WriteLine(dr["Name"]); nCount++; } conn.Close(); Console.WriteLine("total:{0}", nCount); } } you might need to turn on Read permission for Admin user in MS Access:1. check Tools->Options->View->Show->System objects2. Tools->Security->User and group Permissions Select MSysObjects from object names check 'Read Design'
using System.Data.OleDb;public class GetTable
{
public static void Main()
{
string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb;User ID=admin;";
OleDbConnection conn = new OleDbConnection(ConnectionString);
conn.Open();
OleDbCommand cmd = new OleDbCommand(" SELECT Name from MSysObjects WHERE Type = 1 and Name not like \"MSys%\"", conn);
OleDbDataReader dr = cmd.ExecuteReader();
int nCount = 0;
while (dr.Read())
{
Console.WriteLine(dr["Name"]);
nCount++;
}
conn.Close();
Console.WriteLine("total:{0}", nCount);
}
}
you might need to turn on Read permission for Admin user in MS Access:1. check Tools->Options->View->Show->System objects2. Tools->Security->User and group Permissions
Select MSysObjects from object names
check 'Read Design'