I got too much stuff suggesting to use ado in the new versions of the access and also stuff suggesting to use dao further.
I am converting from access 97 to access 2002 and further on i will have to put sql server in the backend and access in the front end.
Should i keep working with DAO or should i use ADO or perhaps both?
waiting 4 answers

ADO is better choice.

Please check the following post for similar discussion:

http://p2p.wrox.com/topic.asp?TOPIC_ID=3746

Om Prakash

Just upsized a big examination database to SQL Server 2008 from Access 2007. I want somebody to give me simple and correct VBA codes to access the ADO tables.

Laide Onabanjo,

This is a very old post. You should only reply to a thread if you are trying to answer the original post.

Please start a new post to as your question. Look for the New Thread button in the upper right or lower left.

__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015