Hi Guys,

I need to get all the tables in a MS Access database using C#. Do you know any class or functions in C# that will return me all the tables when I give it the name of the MS Access Databse.

Just use the jet driver after that everything is just using the SQL query

http://www.csharphelp.com/archives/archive70.html

here is a link you can refer too, if you have visual studio 2005 then this thing can be done in a matter of couple of min....

Thanks Cyberdude,

I got what I wanted.... I had to use the DataTable class and GetOleDbSchemaTable function from the OleDbConnection.

You are welcome, i would try using mssql 2005 express edition rather than MS ACCESS, its just better and yes the MSSQL 2005 Express is free

Well, the place I work uses MS Access... that's why..
Thank you again