I am using VB.NET, and have experience coding to open an Access .MDB file for
retrieving/updating data. But I would like to be able to get at the schema
of the database - see the tables list, list of fields for each table, etc.
Specifically, I eventually need to see the linked tables from within an .MDB
file, and determine what is the source of the linked table (similarly to how
you can view this information from within Access when you choose
Tools->Database Utilities->Linked Table Manager).
Is there a KB article which could step me through this?
- Thanks,
JRD
2  4597 
John,
I know you can access that information via ADO, so I see no reason that you
can't do it via ADO.Net. The information is stored in relational tables
within the Access database. These articles should help get your started: http://msdn.microsoft.com/library/de...ssdatabase.asp http://msdn.microsoft.com/library/de...ce10052000.asp
Richard
"John R. Dougherty" <Jo************@discussions.microsoft.com> wrote in
message news:FD**********************************@microsof t.com... I am using VB.NET, and have experience coding to open an Access .MDB file
for retrieving/updating data. But I would like to be able to get at the
schema of the database - see the tables list, list of fields for each table, etc.
Specifically, I eventually need to see the linked tables from within an
..MDB file, and determine what is the source of the linked table (similarly to
how you can view this information from within Access when you choose
Tools->Database Utilities->Linked Table Manager).
Is there a KB article which could step me through this?
- Thanks,
JRD
None of this seems applicable in my VB.NET environment. Both of the
referenced articles have to do w/coding in pre-.NET, and I am having trouble
finding something that is equivalent in .NET. Are there some similar
articles for the .NET environment?
- Thanks,
JRD
"Richard L Rosenheim" wrote: John,
I know you can access that information via ADO, so I see no reason that you
can't do it via ADO.Net. The information is stored in relational tables
within the Access database. These articles should help get your started:
http://msdn.microsoft.com/library/de...ssdatabase.asp
http://msdn.microsoft.com/library/de...ce10052000.asp
Richard
"John R. Dougherty" <Jo************@discussions.microsoft.com> wrote in
message news:FD**********************************@microsof t.com... I am using VB.NET, and have experience coding to open an Access .MDB file
for retrieving/updating data. But I would like to be able to get at the
schema of the database - see the tables list, list of fields for each table, etc.
Specifically, I eventually need to see the linked tables from within an
..MDB file, and determine what is the source of the linked table (similarly to
how you can view this information from within Access when you choose
Tools->Database Utilities->Linked Table Manager).
Is there a KB article which could step me through this?
- Thanks,
JRD
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Lindy |
last post by:
I have a schema file called Asc.xsd which I have added to my .Net
project (VB).
I am using XMLTextWriter in order to create/write data to a new XML file.
How can I access the elements, etc....
|
by: Jeremy Summers |
last post by:
Has anyone run into problems creating typed datasets from complex schemas?
I am attempting to create a Typed Dataset in Visual Studio .Net from a .xsd
schema file for a industry standard web...
|
by: Schorschi |
last post by:
I have an Access MDB that I have created via VB .NET, thus it is an
emply database. I have an XML Schema file (.XSD) that has the schema
for the database, how do I get the XML Schema into the...
|
by: Sean |
last post by:
Hello,
I have the following scenario. I hope someone may help me on this:
I have an ASP.NET web-application that create .xml files according to a
defined schema and they are sent out to our...
|
by: Mike |
last post by:
Hi! I have an Excel 2003 Schema I need to parse to extract elements names.
I am puzzled which System.Xml object can help me. Here's the example of my
schema:
I need to get a collection of...
|
by: LesleyW |
last post by:
Hi
Apologies if this is a really dumb question, but being new to XML and
Schemas, I wonder if giving the namespace for eg xsd or xsi as a website
address means that the user has to be online...
|
by: Atif |
last post by:
Hi
I am using MS Access 2000 and want to open the Schema to know about
Table's structures like column names, data types, primary keys etc.
In SQL Server, we use OpenSchema method of Connection...
|
by: Chris Lieb |
last post by:
I am new to XML Schema and am running into a bit of a snag. I have
defined an XML-based scripting language for an updater program that I
am working on. I would like to make a schema for this...
|
by: Stan R. |
last post by:
Hello, I have xmllint and xsltproc installed and running on both my
linux and win32 platforms, all seems good.
I have a couple questions though.
1) If I have an external dtd file, which is...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
| |
