I have developed a multi-user package called PEPSYS(Professional Examinations Processing System) which has been working with West Africa Health Examinations Board since 2006. The database size has become too big to be efficient. I have run the Upsizing Witzard to convert to MSDE successfully, but I have problems in my VBA codes which do not work with ADO objects. Kindly assist.

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.

__________________
Greg Serrano
Michigan Dept. of Environmental Quality
Air Quality Division