utility or code to convert Access 2 databases

[Jack]

Hi !

Our application is migratting from VB4.16 / Access 2 to VB6 / Access 2002
(or better)

We need a small utility to convert a *.mdb file from Access 2.0 format to
Access 2000 (or better )
We need to use this utility in a batch file, for example.
We would like to perform this conversion without using [ms]access.exe with
is not installed on the many PC which used our application.

If a such as utility does not exist, we'll be happy with a piece of code to
perform this operation.

Thanks,

Jack

 

[david epsom dot com dot au]

You can use DAO 3.6 to convert a Jet 2 database to a
Jet 4 database:

dim dbe as dao.dbEngine
....
dbe.CompactDatabase sOldName,sNewName,,dao.dbversion40
....
If you do not have Access installed, this is all that
is required.



For your further information:

Access 2 stores an Access 2 project in a Jet 2 database,
and
Access 2K+ store a 2K+ project in a Jet 4 database.

An Access project is very similar to a VB project, only
stored in a Jet database.


If you ARE using Access, you will want to convert the
Access project as well as the database.

Only Access can convert an Access project. But then,
only Access can use an Access project. If the PC's do
not have Access installed, they are not using an
Access project, and no Access project conversion is
required.

(david)