Why doesn't my Visual Basic 6 database application with DAO work anymore?

Question

I made a database application in Visual Basic sometime around 2002 on a machine running Windows 2000 and Office 97. I'm now on Windows XP with Office XP. It uses DAO (current ver 3.51) and Data Bound List Controls (current ver 6.0). I don't know which versions of these I used when I compiled it back in 2002. The compiled version works fine. But now when I recompile it with only cosmetic changes it doesn't work. When it updates a record, it puts the information in the wrong field! Is there some simple fix? Do I need to load earlier versions of something? Or can someone point me to a website that describes how to fix my application to work on WinXP with Office XP.

I converted my db to Access 2000 and changed all my DAT controls to Access 2000 but it still doesn't work.

My database is currently in Access 97 format.

MS Jet 4.0 says it comes with DAO 3.6. I switched my reference to that and changed my recordset, database and querydef dim statements to dao.recordset, etc. but it still does the same thing.

Answer 1

'm not positive but I believe Office XP no longer supports DAO...using ADO instead. If your VB6 application hits an Access97 database it will work fine, but hitting any Access version after that will be problematic. Try loading an Access97 version of your db.

Answer 2

DAO still works... MS Office 2000 and up need version 4.0