ADO or DAO or what?

[philfer]

I came across the following line in a piece of code :-

Set RS = CurrentDb.OpenRcordset (SELECT * FROM mytbl

I feel confident enough to assume that this is not ADO, but is it DOA or something else.

There seems to be so many ways to interact with tables/queries (ADO, DAO, dynamic queries in VBA, running stored queries using ADO) that I get quite confused as I want to build and code the most efficient, optimised database

Any help would be appreciated

Thanks
Phil

 

[RuralGuy]

If it helps you, CurrentDB is DAO.

 

[ChrisO]

G’day Phil.

Not wishing to confuse the issue here but most DAO can be written without concern for the references which may or may not be set.

There are, of course, people who disagree with me on this but I’ve never had any proof presented to me that in anyway invalidates the method.
(Lots of words but no proof.)

Something in the Code Repository may help to explain.

Regards,
Chris.