visualbasic
asked on
Wht have i had so many problems with ADO
I have just migrated for using Dao data access to ADO.I have had so many problems with ADO it's not funny.Could it just be a bad run or am I doing something.If anybody is using ADO full time could the help to Reassure me about its merits.
Regards T
Regards T
I use ADO full time since a little more than a year now and I don't want to go back to DAO and/or RDO.
What kind of problem do you have? Do you know that, since it is not "Mature" yet, you have to download SP from time to time (www.microsoft.com/data).
What kind of problem do you have? Do you know that, since it is not "Mature" yet, you have to download SP from time to time (www.microsoft.com/data).
I fully agree with emoreau
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Kishore:
That's not really an answer . . .
visualbasic:
Switching from DAO to ADO can be problematic at best, and sometimes it causes so many problems you might want to just rewrite the data access portions of your app.
What kinds of problems are you having?
Wes
That's not really an answer . . .
visualbasic:
Switching from DAO to ADO can be problematic at best, and sometimes it causes so many problems you might want to just rewrite the data access portions of your app.
What kinds of problems are you having?
Wes
Here's another URL to check out on this topic:
http://www.microsoft.com/data/ado/adotechinfo/dao2ado.htm
http://www.microsoft.com/data/ado/adotechinfo/dao2ado.htm
I use both ADO and DAO in my projects so I can swith by changing single conditional directive (ADO=1 / ADO=0). I distribute only DAO version to customers for now - it is also faster on MDB database.