The problem is that VB6 intrinsic controls and data objects default to 3.5
and you now need to use DAO 3.6 to access Access 2K, by specifically filling
in the 'DataSource'. The Wizards are broke because they also default to DAO
3.5.
Take a look at the following:
http://msdn.microsoft.com/library/devprods/vs6/vbasic/vbcon98/vbconin...
tactrlandaccess2000.htm
Oh, to make sure you have all the latest DLLs go ahead and download MSDAC
2.1 from http://www.microsoft.com/data and if you are using Win95 install
the DCOM95.
There is a Data Form Wizard fix, but I was unable to get it to work so I
can't recommend it at the moment till I find out what is wrong with my
downloaded code.
There is another ugly alternative to the Wizards. Export an Access 97 table
from Access 2K. (data is unimportant). Use the Wizard to generate the code
from the 97 database, then go back in and change the references and
properties. Your app is now talking to Access 2K. (Hey, I said it was ugly!)
-ralph
--
-
Quote:> There are at least 2 posts a day on Access 2000 and VB6 problems. There
are
> multiple and various responses. But, I have found this article:
> Q232337 BUG: MFC Wizards Fail with "Unrecognized Database Format"
> It is for Microsoft C++ 6.0, but it does say that there is a BUG in the
> wizards and the only way to fix it is to go back to Access 97. I would
> assume that VB 6.0 would be in the same category. Maybe Microsoft will
get
> around to fixing it.
> wh