Converting Access 2.0 DB to Access 97 DB in VB code

Converting Access 2.0 DB to Access 97 DB in VB code

Post by Jeff Jorgense » Tue, 04 Aug 1998 04:00:00



Does anyone know if there is a way to convert an Access 2.0 database to an
Access 97 database within VB code?  I know you can convert it using Access
97 itself; however this is not a viable alternative since we must do the
conversion as part of a setup utility (and cannot assume that the PC being
setup will have Access 97).

Thanks,
Jeff

 
 
 

Converting Access 2.0 DB to Access 97 DB in VB code

Post by Paul Cleme » Thu, 06 Aug 1998 04:00:00


?Does anyone know if there is a way to convert an Access 2.0 database
to an
?Access 97 database within VB code?  I know you can convert it using
Access
?97 itself; however this is not a viable alternative since we must do
the
?conversion as part of a setup utility (and cannot assume that the PC
being
?setup will have Access 97).

You can use CompactDatabase, but this function will not properly
convert certain database objects.

If your database contains objects other than tables and queries, I'm
afraid Access is the *only* other alternative.

Paul
~~~~