Listing the tables of MS Access (Error is This)
-
:(( OleDbConnection conn = new OleDbConnection(string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Mode=ReadWrite",txtDbPath.Text)); OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT Name FROM MSysObjects WHERE Type = 1"; OleDbDataReader reader = null; try { conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { Console.WriteLine(reader.GetString(0)); lstTables.Items.Add (reader.GetName(0).ToString()); } } catch (Exception ex) { // Providing something like this in your ...(continued) Console.Error.WriteLine("An error occured: {0}", ex.Message); MessageBox.Show(ex.Message.ToString()); } finally { if (reader != null) reader.Close(); conn.Close(); } Error is An error occured: Record(s) cannot be read; no read permission on 'MSysObjects'.
-
:(( OleDbConnection conn = new OleDbConnection(string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Mode=ReadWrite",txtDbPath.Text)); OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = "SELECT Name FROM MSysObjects WHERE Type = 1"; OleDbDataReader reader = null; try { conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { Console.WriteLine(reader.GetString(0)); lstTables.Items.Add (reader.GetName(0).ToString()); } } catch (Exception ex) { // Providing something like this in your ...(continued) Console.Error.WriteLine("An error occured: {0}", ex.Message); MessageBox.Show(ex.Message.ToString()); } finally { if (reader != null) reader.Close(); conn.Close(); } Error is An error occured: Record(s) cannot be read; no read permission on 'MSysObjects'.
try: Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};User Id=Admin;Password= or maybe with double quotes on the password, but i dont think you need them, just let it end at the = Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};User Id=Admin;Password="" or with all default options: Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};User Id=Admin;Password="";Mode=Share Deny None;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False