If your code is chock full of DAO syntax, you'll have to "translate" them to ADO. That's not something that can be discussed here briefly. Google something like
"Microsoft Access" "DAO vs. ADO"
for example and see if you can get some good input on the subject.
Michigan Dept. of Environmental Quality
Air Quality Division