Home > Archive > MS Access data conversion > January 2006 > DAO and conversion









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author DAO and conversion
Martin

2006-01-05, 8:26 pm

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.


Joan Wild

2006-01-05, 8:26 pm

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).

--
Joan Wild
Microsoft Access MVP

Martin wrote:
> 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.



2006-01-06, 7:24 am

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)

"Martin" <mpennings@wanadoo.nl> wrote in message
news:43bd94ce$0$498$
dbd4d001@news.wanadoo.nl...
> 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.
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com