DAO and conversion

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Martin - 05 Jan 2006 21:51 GMT

Hi,

Does anyone have experience with converting a Jet Database 2000 version to
2002-2003?
I have a VB 6.0 program that's using the Jet database by DAO.

Reply to this Message

Joan Wild - 05 Jan 2006 22:24 GMT

You don't need to convert anything. Access 2003/2002 can read a version
2000 just fine (in fact it's the default format in those versions).

Signature

Joan Wild
Microsoft Access MVP

> Hi,
>
> Does anyone have experience with converting a Jet Database 2000
> version to 2002-2003?
> I have a VB 6.0 program that's using the Jet database by DAO.

Reply to this Message

david@epsomdotcomdotau - 06 Jan 2006 10:07 GMT

The data file for Access 2003 is a Jet 4.0 file,
exactly the same as the Jet 4.0 file used by Access 2000.

The DAO object used for Access 2003 is dbEngine.36,
exactly the same DAO object used for Access 2000.

The Access project (forms, reports, modules) stored
inside that file may be different, (although by default
it is the same) but since you are using VB forms instead
of Access forms, the format of the Access forms doesn't
matter to you.

(david)

> Hi,
>
> Does anyone have experience with converting a Jet Database 2000 version to
> 2002-2003?
> I have a VB 6.0 program that's using the Jet database by DAO.

Reply to this Message