How to Create database schema of MSAccess database from VB.NET


I have to create a database schema from an Access database in Vb.Net. I need to get the field names, max. length, description, validation rules, required etc for all fields in all tables in the mdb.

Please provide me the solution as needed.

Thanks in advance.

Vinod J. Nair
Trivandrum, India
vinodjnairAsked:
Who is Participating?
 
nishikanthConnect With a Mentor Commented:
use a dataadapter... link it to the particular MDB table

then use Dataadapter.fillschema(DataTablebName)

This will create a table with the same schema as found in the MDB
0
 
LenBotCommented:
To write this schema to a file which you can then view in IE use the Dataset.WriteXMLSchema to just get the Schema or Dataset.WriteXML(Filestream, XMLWriteMode.WriteSchema) to get the Data and the Schema.  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.