Someone in the Access forum explained that I could retrieve metadata from
Access with the DAO API. I specifically what to retrieve the comments for
each column and table. I also want to retrieve the control associated with
each column in MSAccess.
When I fired up VS.NET to start the project, I could not find the DAO to
import! Where is it? I assume it is a COM interface. I think there is a C
interface too for DAO -- what is that called? Is there a native .NET
interface too?
Thanks,
Siegfried
Jul 21 '05
11  8525 
"David Straker" <ds******@adelp hia.net> wrote in message
news:eV******** ******@TK2MSFTN GP09.phx.gbl... Siegfried,
I can't find any way of retrieving Access-specific column properties (like
the control associated with the Access column) in ADO.NET. It may be
possible but I can't see it. I can infer one in code, from data type,
foreign keys, etc. in ADO.NET but that's pretty laborious. Sorry I
couldn't help, dude.
Will somebody from Microsoft please step in and give the facts to Scott M.
on support for DAO. He's posting the same statements about it not being
supported for 5 years in at least one other forum. I know that the big
move is towards ADO.NET but DAO is in Windows XP which is the most recent
version of Access, Access XP is supported by Microsoft therefore DAO is supported
by Microsoft. Isn't that "Logic 101"?
David, try to understand what I'm saying:
There is a difference between providing a technology for backwards
compatibilty and supporting it. MS has not supported DAO in years. By
support, I mean respond to technical inquiries about it or build new
applications using it. I don't mean include it in a product that always had
it.
If you were to call MS and ask them for support with some aspect of DAO,
they would tell you that they no longer support technical inquiries on DAO
and point you to some MSDN article perhaps.
Above you write: "Windows XP which is the most recent version of Access...".
Umm, no. WindowsXP is the most recent version of Windows (home use).
AccessXP is not a part of Windows, nor does it come with WindowsXP.
You wrote: "Access XP is supported by Microsoft therefore DAO is supported
by Microsoft. Isn't that "Logic 101"?"
Umm, no. AccessXP may allow you to use DAO (I actually don't think it will,
but haven't tried it), but it's native data technology is ADO (as it was as
well in Access 2000).
My entire point Dave is that DAO is the road backwards, you can still walk
it if you like, but MS has had a new road in place for many years now (ADO)
and they even have a newer one (2 years+ already) ADO.NET.
You misunderstand "support" for "can use".
David Straker
"Siegfried Heintze" <si*******@hein tze.com> wrote in message
news:u6******** *****@TK2MSFTNG P10.phx.gbl... Someone in the Access forum explained that I could retrieve metadata
from Access with the DAO API. I specifically what to retrieve the comments
for each column and table. I also want to retrieve the control associated
with each column in MSAccess.
When I fired up VS.NET to start the project, I could not find the DAO to
import! Where is it? I assume it is a COM interface. I think there is a
C interface too for DAO -- what is that called? Is there a native .NET
interface too?
Thanks,
Siegfried
"David Straker" <ds******@adelp hia.net> wrote in message
news:eV******** ******@TK2MSFTN GP09.phx.gbl... Siegfried,
I can't find any way of retrieving Access-specific column properties (like
the control associated with the Access column) in ADO.NET. It may be
possible but I can't see it. I can infer one in code, from data type,
foreign keys, etc. in ADO.NET but that's pretty laborious. Sorry I
couldn't help, dude.
Will somebody from Microsoft please step in and give the facts to Scott M.
on support for DAO. He's posting the same statements about it not being
supported for 5 years in at least one other forum. I know that the big
move is towards ADO.NET but DAO is in Windows XP which is the most recent
version of Access, Access XP is supported by Microsoft therefore DAO is supported
by Microsoft. Isn't that "Logic 101"?
David, try to understand what I'm saying:
There is a difference between providing a technology for backwards
compatibilty and supporting it. MS has not supported DAO in years. By
support, I mean respond to technical inquiries about it or build new
applications using it. I don't mean include it in a product that always had
it.
If you were to call MS and ask them for support with some aspect of DAO,
they would tell you that they no longer support technical inquiries on DAO
and point you to some MSDN article perhaps.
Above you write: "Windows XP which is the most recent version of Access...".
Umm, no. WindowsXP is the most recent version of Windows (home use).
AccessXP is not a part of Windows, nor does it come with WindowsXP.
You wrote: "Access XP is supported by Microsoft therefore DAO is supported
by Microsoft. Isn't that "Logic 101"?"
Umm, no. AccessXP may allow you to use DAO (I actually don't think it will,
but haven't tried it), but it's native data technology is ADO (as it was as
well in Access 2000).
My entire point Dave is that DAO is the road backwards, you can still walk
it if you like, but MS has had a new road in place for many years now (ADO)
and they even have a newer one (2 years+ already) ADO.NET.
You misunderstand "support" for "can use".
David Straker
"Siegfried Heintze" <si*******@hein tze.com> wrote in message
news:u6******** *****@TK2MSFTNG P10.phx.gbl... Someone in the Access forum explained that I could retrieve metadata
from Access with the DAO API. I specifically what to retrieve the comments
for each column and table. I also want to retrieve the control associated
with each column in MSAccess.
When I fired up VS.NET to start the project, I could not find the DAO to
import! Where is it? I assume it is a COM interface. I think there is a
C interface too for DAO -- what is that called? Is there a native .NET
interface too?
Thanks,
Siegfried
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Awah Teh |
last post by:
I am working on a project that involves importing IIS Log files into a SQL
Server database (and these logfiles are big --> Some up to 2GB in size).
Up until now I thought that DTS or the BULK INSERT command was the fastest
method out there, but still proves to be long (taking an average of 45mns to
an hour to process each log file).
Because I have to import the log files from three web heads in my cluster
(therefore 2GB log files per...
|
by: Edward S |
last post by:
I budget for a Project in an Excel sheet as illustrated below. The
months below are usually a 2 year period i.e. 24 months, though it
could be over 24 months depending upon a Project. I then need to
input this in an Access database, where I do a comparison with the
Actual cost. The table “TblBudget” in Access is made of 4
fields, namely: (1) CostElement (2) CostCenter (3) Month (4) Amount$.
At the moment this method is very cumbersome....
|
by: sparks |
last post by:
I have never done this and wanted to ask people who have what is the
best way.
One person said import it to excel, then import it into access table.
but since this will be done a lot, I am trying to avoid this extra
step.
can access read in this file directly into a table as append data?
thank you very much for any pointers
|
by: Timothy Shih |
last post by:
Hi, I am trying to figure out how to use unmanaged code using P/Invoke. I
wrote a simple function which takes in 2 buffers (one a byte buffer, one a
char buffer) and copies the contents of the byte buffer into the character
pointer. The code looks like the following:
#include <stdio.h>
#include <stdlib.h>
#include "stdafx.h"
BOOL APIENTRY DllMain( HANDLE hModule,
DWORD ul_reason_for_call,
|
by: Howard Kaikow |
last post by:
I have files to build a C project, including the makefile, what's the
easiest way to import the project into C and C# in VS .NET Professional? I
have both VS .NET 2002 and 2003.
I have nothing but VB .NET books.
I guess it's time to get a book for each of C++ and C# in .NET.
Any recommendations
--
http://www.standards.com/; See Howard Kaikow's web site.
| | |
by: em |
last post by:
Hi all,
I'm getting some problems importing a DLL that I made in C# within VB6.0.
The C# is quite easy, just for trying:
namespace TestDll
{
public class Class1
|
by: Alun Jones |
last post by:
I'm getting the above error in a dialog box from Visual Studio 2005 when
trying to sign an assembly using a PFX file, and would like to know how to
resolve the problem.
Background:
The PFX file has been used for code-signing before (to sign an InfoPath
form), so therefore the file contains a valid code-signing key.
I have the correct password to the PFX file (because I get a different error
|
by: JMO |
last post by:
I can import a csv file with no problem. I can also add columns to the
datagrid upon import. I want to be able to start importing at the 3rd
row. This will pick up the headers necessary for the datagrid. Once I
can get to that point I need some way to be able to add new data only
to the new columns that were added.
Here is some of my code:
//Function For Importing Data From CSV File
public DataSet ConnectCSV(string filetable)
|
by: Ronny |
last post by:
I need to import the Winform GUI from one project to another(with all the
controls).
Is there a simple way to copy&paste it or must I create every control by
hand
Regards
Ronny
|
by: Hussein B |
last post by:
Hey,
Suppose I have a Python application consists of many modules (lets say
it is a Django application).
If all the modules files are importing sys module, how many times the
sys module will be compiled and executed?
Only once (the first time the PVM locates, compiles and executes the
sys module)? or once for each module importing sys?
Thanks.
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
