Need a good book on Microsoft DAO

[Jim Evans]

Most of the silly How tos? I ask in this group are regarding things I could
do in my sleep with SQL Server.

I need a good book to learn the language and syntax of DAO.

Any suggestions?

Jim Evans

 

[Douglas J. Steele]

One of the best references is whatever version of the Developer's Handbook
is appropriate for you.

http://www.developershandbook.com/

 

[Jim Evans]

Thanks Doug, I have both the Desktop and developers editions for Access
2002. I have not been able to get through either completely. takes time. I
do agree that they are great reference materials.

I was hoping to find something more specifically about DAO though, just as I
am able to buy books on T-SQL. I was hoping for something just covering the
DAO object model and syntax.

Am I correct in the information I have received before that it is better to
work with DAO than ADO in dealing with Access?

What is your opinion of ADO vs. DAO with Access DBs I have agood handle on
ADO from writing .asp and .vbs for about 6 years?

Jim Evans

 

[PC Datasheet]

Beginning Access2000 VBA, Smith and Sussman, Wrox Press
(Don't know if they have a later version)
DAO Object Model, Helen Fedema, O'Reilly

 

[Jim Evans]

Thanks, I will look for these.

Jim

Beginning Access2000 VBA, Smith and Sussman, Wrox Press
(Don't know if they have a later version)
DAO Object Model, Helen Fedema, O'Reilly

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com

 

[Albert D. Kallal]

I was hoping to find something more specifically about DAO though, just as
I
am able to buy books on T-SQL. I was hoping for something just covering
the
DAO object model and syntax.

Hum, well, I suppose some documents on converting DAO to ADO would help!!

There is a good one in the knowledge base...but it is down as I write
this...
Here is a good one:

Am I correct in the information I have received before that it is better
to
work with DAO than ADO in dealing with Access?

It *can* be a bit better, but is rarely a deal breaker here.

What is your opinion of ADO vs. DAO with Access DBs I have agood handle on
ADO from writing .asp and .vbs for about 6 years?

Oh, gee, you eat and think in ADO. Go with it!!. You might as well leverage
your skills here. The DAO object model simply came before ADO. Ms-access
happily supports both. I would stick with ado. The differences are little,
and I can't see even issues of performance making a difference here.

'An example DAO vs ADO recordset loop, you'll see how similar they are:

'--- begin DAO ---
Dim rst As dao.Recordset

Set rst = CurrentDb.OpenRecordset("select * from contacts")
Do While rst.EOF = False
Debug.Print rst!FirstName
rst.MoveNext
Loop
rst.Close
Set rst = Nothing
'--- end DAO ---

'--- begin ADO ---
Dim rs As New ADODB.Recordset

rs.Open ("select * from contacts"), CurrentProject.Connection
Do While rs.EOF = False
Debug.Print rs!FirstName
rs.MoveNext
Loop
rs.Close
Set rs = Nothing

You got the currentProject.Connection that gives you ready a connection
object at all times. So, I would use ADO. It is newer, and it is what you
know. About the only disavantage here is that a "ton" of example code etc.
is posted in DAO...

 

[Paul]

Check out Microsoft Jet Database Engine Programmer's Guide
I have it and it is definitely a good buy. Also, 5 stars on Amazon.

--
Michael Badnarik for President '04
Libertarian...the freedom party
www.lp.org
www.badnarik.org

"If you are in prison and your chances are 50% for execution by electric
chair, 45% for execution by lethal injection, and 5% for escape, are you
just going to vote for the chair because it is the likeliest outcome?" Vote
Libertarian and live to be free.

 

[Jim Evans]

Thank you, Albert.

Well thought out, sensible advise.

Jim Evans

 

[Jim Evans]

Thanks, Paul.

It is now out of print but, I was able to order a used one on Amazon.

Jim Evans

 

[Van T. Dinh]

There is a Access 2002 version of this book.

 

[Van T. Dinh]

A minor point to note: This book is for JET 3.5, i.e. the JET version used
in Access97.

There are a number of new syntaxes introduced in JET 4 (the JET version used
in A2000 & later ...). However, the commonly-used syntaxes are still the
same between JET 3.5 and JET 4.

 

[Jim Evans]

Thanks for the clarification, Van

Jim

A minor point to note: This book is for JET 3.5, i.e. the JET version used
in Access97.

There are a number of new syntaxes introduced in JET 4 (the JET version used
in A2000 & later ...). However, the commonly-used syntaxes are still the
same between JET 3.5 and JET 4.