How to get table def of access database using vb .net

Question

0.00/5 (No votes)

See more:

I have a mdb with multiple tables, i want to get the list of table definitions (ignore system tables) and fields inside each table.
I used DAO to get the data in vb6 but i want to use vb.net and access 2010.

I am new to vb .net so if possible please share sample code.

Thanks.

Posted 16-Jan-14 10:18am

Member 20

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2014-01-16T10:31:00

Solution 1

Forget about DAO. ADOX[^] is what you're looking for.
Listing the Tables in an Access Database[^]
Creating and Modifying Access Tables[^]

Posted 16-Jan-14 10:31am

Maciej Los

Comments

Member 20 16-Jan-14 16:47pm

Thanks for the links, i am checking.
How to verify system tables are present or not?

Maciej Los 16-Jan-14 16:50pm

Just follow the links (second one - contains infrormation about system tables).

Member 20 21-Jan-14 15:22pm

Hi,
Can you share example of oledb instead of ADOX.
I have to use adodb or oledb, i am getting list of tables using GetOleDbSchemaTable, but i am not able to access the columns inside each table in .accdb.

Thanks.