Converting Access 2.0 to Access 97 or 2000

Converting Access 2.0 to Access 97 or 2000

Post by Jonas Bergma » Sat, 18 Dec 1999 04:00:00



We have developed a software used by approx. 1000 customers. The
software was originally developed using VB3 and Access 2.
We are now planning to convert this software, and all databases, to
32-bit.
I would like to know if there are any tools that we can distribute so
that the installation software can convert all databases to a newer
version of access. We would of course need all data to be transferred
and Counter fields should not get new values, since relations are based
on these fields.
 
 
 

Converting Access 2.0 to Access 97 or 2000

Post by Paul Clemen » Tue, 21 Dec 1999 04:00:00


On Fri, 17 Dec 1999 00:57:05 -0800, Jonas Bergman

We have developed a software used by approx. 1000 customers. The
software was originally developed using VB3 and Access 2.
We are now planning to convert this software, and all databases, to
32-bit.
I would like to know if there are any tools that we can distribute so
that the installation software can convert all databases to a newer
version of access. We would of course need all data to be transferred
and Counter fields should not get new values, since relations are based
on these fields.

If there are no Forms, Reports, Modules etc. within the Access
database you can use the CompactDatabase method of the DBEngine
object. Otherwise you will need to use the Microsoft Access
application.

Paul
~~~~