Solved

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

Posted on 2004-03-31
4
243 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
Comment Utility
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
Comment Utility
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

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 …
The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

728 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now