Solved: DAO vs ADO

[philfer]

Hello,

If you have a DB that will stay in Access i.e. there is no forseeable intention to upsize it, say, to SQL Server, is it better to use DAO which is optimized for the Access Jet DB Engine rather than ADO.

I know ADO is newer and there has been talk of DAO being phased out (which I believe is not the case) but if it results in better performance wouldnt it be better to stick with DAO.

Thanks for your thoughts
Phil

[stanl]

To be honest with you - who cares. If the company you work for (assuming) doesn't want to rock the boat then don't rock the boat. If you have job security forever, then don't rock the boat.

However, size and skill do matter... and ADO fits the bill (unless, of course, where you are located there are abundant ads "Wanted skilled DAO Programmers") .02 Stan

[CreganTur]

I feel that ADO is easier to use, is much more flexible, and is definately the more forward-thinking approach when you think about the future. ADO is also the preferred method of the .NET environment, so if you ever learn .NET and decide to interface with your Access DB it would be helpful to already know ADO.