Solved

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

Posted on 2004-03-31
4
244 Views
Last Modified: 2012-06-21

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
Comment
Question by:vinodjnair
4 Comments
 
LVL 8

Accepted Solution

by:
nishikanth earned 40 total points
ID: 10729983
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
 

Expert Comment

by:LenBot
ID: 10782493
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A basic question.. “What is the Garbage Collector?” The usual answer given back: “Garbage collector is a background thread run by the CLR for freeing up the memory space used by the objects which are no longer used by the program.” I wondered …
In my previous article (http://www.experts-exchange.com/Programming/Languages/.NET/.NET_Framework_3.x/A_4362-Serialization-in-NET-1.html) we saw the basics of serialization and how types/objects can be serialized to Binary format. In this blog we wi…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question