I have a MDB that consists largely of a number of linked tables to
external data files, which contain various activity data. I then open
this db from my ADP project using OpenDatabase and OpenRecordset,
which I believe are based on DAO (are they?).

I am in the process of attempting to remove all DAO code from the ADP.
I have never used ADODB to open an MDB, however, and I was wondering
if anyone has a few pointers? It's pretty simple code...

   'open the file via the linked table in the mdb, and check the date
inside it
   Set db = OpenDatabase("L:\Tools\Reconciliation
\Reconciliation.mdb")
   Set act = db.OpenRecordset("Activity")
   startDate = CDate(act.fields(1))

I'm hoping this can be converted to something using ADOBD and
connection strings. I'm pretty familiar with these, but they seem to
be extremely fragile so any advice to start would be great!

Maury