ADO vs DAO

[ChrisMalter]

I am developing an application with VB.Net. Currently I am storing my data in an Access 2000 database. Should I connect to this databse via ADO or DAO. I am more familiar with DAO because I have used it when developing applications in Access. I have been told that using ADO was pointless because I am using Access and not SQL Server.

However, I want to develop this application with scalibilty in mind. I may in the future choose to move over to SQL Server and I would like to develop my front end so that the transition would be a simple one. Keeping this is mind, Does anyone have some suggestions as to how to go about developing the front end? Should I create a code module that connects to my database? Or should I connect to the database with each form i create?

Thanks.


-Chris

[DevGrp]

I have been told that using ADO was pointless because I am using Access and not SQL Server.

Whoever told ou this is retarded, j/k. Seriously though, you should use ADO, and since you are using .NET, might as well use ADO.NET. This is much better than ADO imho.

Yes, use code modules for the DB, that way all your DB code is located at one centralized place. No hunting when ou want to change it latter.

[Cander]

neither. You use ADO .NET.

[bell]

Can u use the DAO Object in
.net
I thought it gone.

[ChrisMalter]

Thanks for the replies. I didn't realize there was a difference between ADO and ADO.NET. I haven't looked into it yet, but I guess now I should start. Anyone recommend where to find some good articles on ADO.NET?

-Chris

[abdul]

http://samples.gotdotnet.com/quickst...soverview.aspx