Access and VB enterprise

M

marks

When I try to use VB to open a database built in Access 2003 it says that it
does not recognize the format. I am using VB 6 enterprise edition with
Microsoft office 2003. If I create a database using any prior version of
Access, VB recognizes it the format. Any feedback would be greatly
appreciated.
 
J

Jon Furman

Sounds to me like you need to install a newer verison of MDAC and/or latest
jet drivers if they are not included in MDAC. The MDAC used to install
everything but I believe that it has become somewhat fragmented recently and
some items must be installed seperately.Just make sure you get the newest
OLDDB provider for Jet one way or another. Once you reference in the newest
OLEDB provider for jet into your VB6 project and I bet that things will
begin to work.


Jon
 
Top