Choosing an Access VBA Book

D

durdle

Registered User.
Local time
Today, 17:35
Joined
May 7, 2002
Messages
130
Hey,

Anyone know a good access vba book for beginner's?
Note: I am new to vba.

Thanks
________
jugalettes
 
Last edited:
the dummies programming book series is pretty good
 
Depending on which version of Access you are programming in: anything by F.Scott Barker I have found to be very good. My favorite is Access 97 Power Programming. I think he has 1 for each version. He really goes into detail about why you do things certain ways in VBA.
 
Dgar007, I have that book. I think he does a great job explaining things, but I don't think it would provide quite as much hand holding as the Dummies book would (which I have not seen). If durdle is committed to learning and ambitious, then Mr. Barker's book could be just the ticket. I used that book when I was learning and it inspired me to delve deeper.

Durdle, you just need to make sure that the book you buy is appropriate to your version of Access. There are two data access technologies (DAO and ADO) that are used in concert with VBA to control Access programatically. I don't think any book covers both (because it would be too fat). DAO was the "preferred" technology (according to Microsoft through version 97 of Access), after that, ADO became preferred. DAO will still work with all later versions of Access, except that, from what I hear, ADO is generally easier to use with ADP files.
 
Best to go with ADO if you plan to scale up to SQL Server. From what I gather DAO was designed to connect Access objects to Jet databases. Whereas DAO was designed to connect Access objects with just about anything.
 
I think VBAhole22 meant "ADO" in that last sentence. ADO was meant to be a universal data solution connecting everything to everything else. DAO is optimized to worked with just mdb files.
 
Ooops, you're correct

darn acronyms. What will the next model be DOA?
 
You mean going from Access XP to Access DOA? Sometimes it feels that way....:D
 
Thank you all for your replies.

Pat,

Just one quick one, to a novice like myself, what is ADO and DAO?

Note:I have Access 97 at work but I have XP home, I think I will downgrade to 97 @ home because we will not be upgrading at work.


durdle
________
website design
 
Last edited:
Hey,

If I decide to go with ADO will I miss anything regarding DAO?

Durdle
________
chrysler uk
 
Last edited:
Durdle,

Sources I've read say DAO performs better than ADO in an all Jet environment (you are using Jet when your Access file has an MDE or MDB extension). Also, there is more functionality (you can do more stuff) programming Access/Jet security with DAO rather than ADO.

Most sources also agree, however, that ADO (evolved to ADO.NET in other Microsoft products like ASP.NET and VB.NET) is Microsoft's choice for the long-run, vaguely speaking, and that while DAO will be supported for the foreseeable future (about two weeks? two years? people are still writing batch files with DOS commands so who knows?) it will not be further developed.

Regards,
Tim
 
Guys, can you even use ADO with Access 97? I think so depending on what software is installed on your PC (like if you have Access 97 and 2000 installed on the same PC), but I've never tried it.
 
Since you are using Access 97, and especially if you're just working with MDB files, you can stick with DAO. The book in the link deals with DAO. It was written specifically for Access 97 which was shipped with DAO.
 
Hey Everyone,

I have changed my mind with regards to DAO & ADO. I am going to purchase a book that deals with ADO. Since I have Access XP at home I will purchase a Novice/Beginner VBA book dealing with ADO, anyone have any ideas?

I was think about the book Pat recommended "Access Database Design & Programming(3rd edition) by Steven Roman" but I read in one of the reviews it uses DAO.

Sorry for all the trouble
________
honda cb500
 
Last edited:
I don't have the book, but see if it's sold on Amazon and if they have any excerpts. They might have the table of contents. Look to see if it mentions ADO or DAO. Also, you could se if your local bookstore has it and browse.
 
You must log in or register to reply here.

Similar threads

W
Access VBA References
Replies
6
Views
248
GPGeorge
GPGeorge
N
MS Access VBA Vs JAVA
Replies
2
Views
672
CJ_London
C
M
  • Question Question
update dataentry through form
Replies
2
Views
468
GPGeorge
GPGeorge
C
Using Access to update a Sharepoint "Choice" field
Replies
17
Views
1,221
MajP
MajP
J
Solved Read Type Information (Classes & Methods) from COM DLL
Replies
11
Views
1,423
D_Walla
D

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom