[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

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
0
vinodjnair
Asked:
vinodjnair
1 Solution
 
nishikanthCommented:
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now