Is DAO Depreciated?

[Uncle Gizmo]

I note in the book “Mastering VBA for Microsoft Office 2016” that they say, in comparing ADO and DAO that DAO is the older technology and is depreciated, (no longer approved of) But I thought they had brought DAO back for Microsoft Access? I’m confused! Anybody got any insight into this? I am writing an article exploring the differences between ADO and DAO any comment information suggestions you could make that is relevant to this comparison would also be most welcome.

 

[Uncle Gizmo]

It gets more confusing. Reading deeper into the book they demonstrate both methods both ADO and DAO and also provide a link to what appears to be an old Microsoft page HERE:-

https://msdn.microsoft.com/en-us/library/aa164825(office.10).aspx

 

[Minty]

My limited understanding was that ADO was deprecated in the later versions, after they went down the sharepoint route? I thought DAO was back in the "we love you" fold?

 

[gemma-the-husky]

it's hard to see how DAO could be deprecated.

The whole of access table and fields collections (and others) is based on DAO, isn't it?
Can you get at the detail of these in other ways?

 

[Uncle Gizmo]

can you get at the detail of these in other ways?

................... ......................

Adox?

 

[sneuberg]

I have the 2013 edition of that book and while it says, "DAO is the older technology to access data, ..." I haven't found the the word "depreciated". They also have that that same link https://msdn.microsoft.com/en-us/library/aa164825(office.10).aspx that's pretty old (1997).

 

[gemma-the-husky]

................... ......................

Adox?

Maybe it changed after Jet.

I have O'Reilly DAO Object Model - A super reference book.

Quote on the back

The object model that is perhaps in most widespread use today is DAO, the object model of the Jet database engine.

 

[BeeJayEff]

I haven't found the the word "depreciated"

If you're just doing a simple search, bear in mind that the word is "deprecated", not "depreciated".