Talk about being new. I am currently in the process of converting from R:Base for DOS to ACCESS 2000. Is there a diference between visual basic in access and vb6. From the few books I have been reading, I should learn activeX (ado) to connect to databases and stay away from dao. At this point I don't know either one, I had been progamming in C for the last 10 years. Can anyone recommend any good ado books or any other good starting points for someone who understands programming concepts, but I need to know how to do it in VB not C.
10-04-2001, 12:11 PM
From what I understand, the main difference between VB for Access (VBA) and VB6 is the objects that you work with. One of the best books on VBA I have ever read is VBA Developers Handbook which also comes with Access Developers Handbook although I have the '97 version. It is published by SYBEX and is wrote by Ken Getz and Mike Gilbert.
As far as ADO and DAO go, I would certainly suggest learning ADO and Microsoft are no longer developing DAO.
Good Luck with your project.
10-04-2001, 12:13 PM
The only reason to stay away from DAO with an Access database is it is
There is a very good database example project by dcl3500, in the Code
I think therefore I am... sometimes right. images/icons/wink.gif
10-05-2001, 01:16 AM
I only use DAO (I'm no db expert) but as I understand it, ADO is more flexible and allows you to connect to all kinds of databases. DAO is more or less configured for Access which makes it less flexible, but it is far quicker than ADO at connecting to Access.
"I have a plan so cunning you could put a tail on it and call it a weasel!" - Edmund Blackadder