I think you've got the terminology a little back to front. Common database
access technologies include DAO, RDO, ADO in order of history. The
recordset type is another thing altogether.

DAO is the most mature and flexible. 2.5 is present on everything from 95
to Win 2k. However it's not on XP, or at least it wasn't on a project I was
recently involved with.

So if you're after pinning your colours to a particular technology I'd go
with ADO 2.5. One thing with ADO though is that in order to create
databases and do some other administrative type things you need to use ADOX
which is another component. Not sure about the availability of this client
side. DAO let you do everything in one place. In an attempt to streamline
ADO and make it less bulky Microsoft removed these kind of features from
ADO.

--

Regards,


Bill Lunney
www.billlunney.com

";-)" wrote in message
...
In VBA for Excel 97 the default type of recordset is DOA.

What is the default type on Excel 2000, and XP?


I need to know since I don't want the client to have to install the latest
MDAC to get my Excel modifications to work. (They supplied the originals,
I
made modifications, they will maintain them)