Connecting to an Access Database

[Husamuddin]

I was wondering if anyone knew of a way to retrieve, edit and insert records from a VB form into an Access database, one that does not involve OleDb.

 

[Hack]

What is the issue with OleDb?

 

[Husamuddin]

Nothing, actually. I've decided to use it after all.

However, while I am using it. Suppose I enter the path to .mdb file, how do I produce the names of the tables contained in it?

 

[Husamuddin]

Anyone at all?

 

[JuggaloBrotha]

Like this: List Tables In Database - VB.NET - Source Code | DreamInCode.net ?

or this: Get list of tables in ACCESS using VB.Net app

 

[Husamuddin]

Thanks, that was a great help.
If I may ask, how do you get the names of columns in a table?

 

[JuggaloBrotha]

You have a DataTable object, you can either loop it to to get the names, or bind it to a control and set the DisplayMember to "TABLE_NAME"