DAO vs ADO

[krymat]

Would it be worth the effort to recode all DAO to ADO syntax(for databases that will be migrated for many more access generations)?

Any performance benefits?

When will DAO be dead?

 

[LSTAN]

Hi

You might want to read the article from MS, it's titled Migrating Issues of DAO/ADO

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q225048

Hope you will find it helpful

rgrds
LSTAN

 

[Laois]

Yes it would because DAO is already dead and probably will not be supported in future versions of Access. So at some point your going to have convert. As for performance it will depend on what you are doing. ADO is more powerful and has more features. For example you can write a recordset to an XML file or read an XML file in to a recordset with just one line of code.

I stoped using DAO 2 years ago and never looked back, but still amazes me how many people are still using it.

Well that's what I think.

 

[cmmrfrds]

What I like about ADO is that the objects and syntax is the same whether you are using Microsoft Access or ASP and I believe it is true of many other GUI systems. Since, I was accustomed to using ADO it was relatively easy to pick up doing ASP since I didn't need to concentrate on data access. There are many OLE providers including oracle, exchange, active directory, in addtion, to Excel, Access and SQL Server. So, learning one library of data access objects (ADO) can be used to manipulate many types of data.

 

[KellyK]

I got a "page cannot be found" error when I clicked on the link, LSTAN, but maybe it's just me?

 

[krymat]

Just lookup knowledge Base article Q225048