>it does look like that is what i'm going to have to do. also, it looks like i need Access2000 from what i can tell. to get the jet driver, do i just need to re-install mdac?
All version of ADO since at least 2.1 supports A2K databases (when using Jet.OLEDB.4.0 driver).
If your MDB was created with A97, it won't help opening it with this newer driver.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com