How to get list of Tables in MS Access using C# code
The text of this article is not in this database — only its details are. The old site it was published on is gone, but the Internet Archive kept a copy: How to get list of Tables in MS Access using C# code
5 Comments
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
shahid bhatPosted May 22, 2019, 2:40 AM
Nice explanation
Sr KarthigaPosted Feb 26, 2016, 9:15 AM
good one
Sr KarthigaPosted Feb 26, 2016, 9:15 AM
nice explanation
Amit ChoudharyPosted May 8, 2010, 6:46 AM
hi friend, first of all i want to mention here that for 2007 access database the file extension is accdb not mdb. so you have to use providers for 2007 here what i have mentioned in the article are for mdb file i.e., for 97-2003 version. for 2007 you have to mention following providers: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False; after looking at your code.. i found you want to open the file as a seperate process.. tell if you want to acess it from code behing by database connectivity or as seperate process..??
Ritha NPosted May 7, 2010, 1:32 PM
Sir, I hav created one web form using ASP.NET-C# and database Mhe s Access 2007. I did save my database in .mdb format. i want to open a particular table from the database in a button click. The codes i have written s working fine to open the complete database protectedvoid btnOk_Click(object sender, EventArgs e) { Process mProcess = newProcess(); mProcess.StartInfo.FileName = "D:\\Trade Enquiry Management System\\App_Data\\TenderEnquiryManagementSystem.md b"; mProcess.StartInfo.WindowStyle = ProcessWindowStyle.Normal; mProcess.StartInfo.CreateNoWindow = true; mProcess.Start(); mProcess.WaitForExit(); if (!mProcess.HasExited) { mProcess.Kill(); } mProcess.Close(); } Bt i want to open a table 'Enquiry' under TenderEnquiryManagementSystem.mdb 'll u pls help me to get the code for that????