Opening an Access2K file with VB6

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan Shelby - 24 Oct 2003 16:46 GMT

I would like to open an Access2000 database file in Visual Basic 6. When I
try it tells me that the database is in the wrong format. If I convert the
database to Access97 format, then the file opens with no problem. I have
tried the ADO route, and the DAO route, all to no avail. Obviously there is
a way to do this but I haven't been able to figure it out. Appreciate any
help you can give. Thanks.

Reply to this Message

Alfie [UK] - 24 Oct 2003 17:26 GMT

Some time on Fri, 24 Oct 2003 10:46:12 -0500, "Dan Shelby"
<daniel.shelby@cox.net> posted that:

>I would like to open an Access2000 database file in Visual Basic 6. When I
>try it tells me that the database is in the wrong format. If I convert the
>database to Access97 format, then the file opens with no problem. I have
>tried the ADO route, and the DAO route, all to no avail. Obviously there is
>a way to do this but I haven't been able to figure it out. Appreciate any
>help you can give. Thanks.

It's to do with the data control used, have a look at
http://tinyurl.com/s7ue

Signature

Alfie
<http://www.delphia.co.uk/>
Computers are like air conditioners: They stop working when you open Windows.

Reply to this Message

the Wiz - 24 Oct 2003 22:22 GMT

Are you using the latest Jet engine from Microsoft? Not the latest MDAC, which
doesn't contain the Jet engine.

More about me: http://www.jecarter.com/
VB3/VB6/NSBasic Palm/C/PowerBasic source code: http://www.jecarter.com/programs.html
Drivers for Pablo graphics tablet and JamCam cameras: http://home.earthlink.net/~mwbt/
johnecarter at@at mindspring dot.dot com. Fix the obvious to reply by email.

Reply to this Message

Dan Shelby - 25 Oct 2003 17:43 GMT

How do I determine whether or not I have the latest Jet Engine and what is
MDAC? Thanks for your answer!!

> >I would like to open an Access2000 database file in Visual Basic 6. When I
> >try it tells me that the database is in the wrong format. If I convert the
[quoted text clipped - 10 lines]
> Drivers for Pablo graphics tablet and JamCam cameras: http://home.earthlink.net/~mwbt/
> johnecarter at@at mindspring dot.dot com. Fix the obvious to reply by email.

Reply to this Message

Richard Iain Blakeway - 31 Oct 2003 04:05 GMT

off the top of my head a97 uses jet3, 2k uses jet4, look for the dll.

> How do I determine whether or not I have the latest Jet Engine and what is
> MDAC? Thanks for your answer!!
[quoted text clipped - 21 lines]
> > johnecarter at@at mindspring dot.dot com. Fix the obvious to reply by
> email.

Reply to this Message

VB Forum / General 2 / October 2003

Opening an Access2K file with VB6