using DAO to retrieve access data in C#

Question

5.00/5 (1 vote)

See more:

Hi,
Does anyone know how to retrieve the data from Access MDB file using DAO?
Please help.
What references, dll's do I need?
I can't find any examples.
Thanks.

Posted 8-Jun-11 8:20am

milanski19

Updated 19-Jun-22 9:17am

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Iao from Macau · Answer 1 · 2011-06-26T08:27:00

In VS 2010, open the "Solution Explorer" > "Reference" > "Add Reference" > ".Net", you can see the component "dao", add it to reference.

Now you can use DAO in your project. See below:

internal static dao.Database DAODataBase;
private dao.Workspace DAOWorkSpace;
private dao.DBEngine DAODBEngine = new dao.DBEngineClass();
DAODataBase = DAOWorkSpace.OpenDatabase("C:\\MyData.mdb", null, null, ";pwd=");
internal static dao.Recordset DAOFoundCode;

Dao is faster than OleDB. I retrieve 20000 row data from 350000 row data with 140 ~ 200 ms, but OleDB needs 500 ms to fill DataSet.

Iao

Kim Togo · Answer 2 · 2011-06-08T08:55:00

Solution 1

DAO is really an old data access mechanism. Skip it, and start using OLE DB[^]

Posted 8-Jun-11 8:55am

Kim Togo

Comments

milanski19 9-Jun-11 8:58am

I know it is, and I made it work the new way with ADO instead and OLE DB but this was a converted Application from VB to C# and it has DAO mechanism in there and also uses an old 97 Access read only DB so I need to fix that. Other than that of course I wouldn't bother with it but I was asked to fix it as is.
Thanks for replies my friends.

Uday P.Singh 26-Jun-11 14:42pm

good answer my 5!

Kim Togo 27-Jun-11 3:33am

Thanks Uday

Dave Kreskowiak · Answer 3 · 2011-06-08T09:50:00

Solution 2

Why? DAO was deprecated well over a decade ago.

There's a reason you can't find any examples. Noone uses it anymore!

Posted 8-Jun-11 9:50am

Dave Kreskowiak

Comments

milanski19 9-Jun-11 9:00am

I know it is, and I made it work the new way with ADO instead and OLE DB but this was a converted Application from VB to C# and it has DAO mechanism in there and also uses an old 97 Access read only DB so I need to fix that. Other than that of course I wouldn't bother with it but I was asked to fix it as is. Thanks for replies my friends.