difference between DAO and ADO?!?

[wshm]

I am currently building a budget(datebase) program using
MS Access 2003. I've been told that I should program(VBA) in ADO. I've done some research about DAO and ADO and yet
I have no idea what it means to "write your code in ADO"
is it the syntax that's different?
My company is planning on making this program available
through the web and they're planning on training me in
IIS/Web Developer, etc. I don't see any relavance to all this.. Maybe i'll understand as I learn more about them but
i would like to gather some information and prepare myself.
any idea where i might be able to find more information?

 

[wshm]

oh yea, forgot to mention another thing.
I've designed another program and I guess I need
to convert it to ADO? how do I do that?
I've searched through some forums and found a way
to check your codings (ctrl+g/vba window -> tools ->
reference)and it seems like i've used both?!?
any help would be appreciated.

 

[Remou]

There have been a number of posts on this issue, here are two:
DAO vs ADO?
thread705-1225294
DAO vs ADO / What are the advantages & disadvantages of each?
thread705-1110987

You will probably find that ADO is more useful to learn if you intend to do web development.

 

[wshm]

omg.. i meant asp...

 

[wshm]

how can i set it so that i don't use DAO?
turn off DAO library? sorry, im new to all this..

 

[Remou]

You can untick the reference, but it may be more suitable to write the whole thing in VB, ASP or ASP.Net with Access serving only as a database. It depend on where it is all going.

 

[fneily]

Oh, it's the holidays and I'm feeling a little rambunctious from my homemade eggnog.
Standing afar from Mr. Remou, I shout out "You can create DAP's (data access pages)". And then I run away. (Mr. Remou and I have a difference of opinion about DAP's).

 

[Remou]

I respect your opinion on DAPs fneily, in fact, I have stood back from posts where you espoused them, but wshm mentioned that "I've been told that I should program(VBA) in ADO" and "My company is planning on making this program available through the web and they're planning on training me in IIS/Web Developer, etc." and finally "omg.. i meant asp...", so I think it is, perhaps, wshm's people that you need to convince.

 

[fneily]

Actually, you bring up a good point - I wonder if the ones who decided that he should be trained in (ASP) even heard of DAP's? I have been to some company's IT departments that never knew they existed. Oh well, have a good day.