I was wondering, what is com, adn how does it relate to MS access
Printable View
I was wondering, what is com, adn how does it relate to MS access
COM is the Component Object Model, and it's probably one of the most important things to Microsoft. Example: all the Office programs can be used as COM objects (ever used CreateObject("Word.Document")?). Also, all OCX controls are COM objects. ActiveX is another name for COM. Now, you can see where it all fits in.
On the Access side, DAO and ADO are usable through COM in a variety of different guises.
what is ado, and dao?
ADO - Active Data Objects
DAO - Data Access Objects
They're two different object-centric ways of accessing a data source.
whats the diffrence between them?
From what I can tell, not a whole lot. I've used both interchangeably (to an extent). I haven't done much MS database stuff for a while (decided I preferred mySQL and C++).