Access97 connection
-
I am using OleDBConnection to connect Access97 file. While connecting using wizard and clicking on testconnection button it shows an error "MSysAccounts table cannot open" How can i connect to Access97 by OleDbConnection Thanks In advance Panal
-
I am using OleDBConnection to connect Access97 file. While connecting using wizard and clicking on testconnection button it shows an error "MSysAccounts table cannot open" How can i connect to Access97 by OleDbConnection Thanks In advance Panal
string ms_connection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;"; OleDbConnection mc_connection = new OleDbConnection(ms_connection); string ms_sql = "select * from table"; OleDbCommand mc_command = new OleDbCommand(ms_sql, mc_connection); OleDbDataReader rReader = mc_command.ExecuteReader(); rReader.Read();or words to that effect Web design and hosting http://www.kayess.com.au -- modified at 8:15 Friday 28th April, 2006