Ok we have a couple of apps in VB5 which worked fine with Access97. Some mental giant decided it would be a really good idea to upgrade everything to Access2000. Die lamer Die.

Ok DAO connections don't work, so posted a question about this on a couple of boards, and was informed that we needed to use DAO3.6, (which apparent gets loaded with Access2000.

This is the problem:

IN vb's components and references there is no mention of DAO3.6, we still only have the 97 versions. Anyway found out how to get around this? The local Microsoft help line are their usual total waste of space on the issue.