If you convert a Jet3 [DAO 3.5] database to Jet4 [DAO 3.6] using VB6's
CompactDatabase function the database will be converted to Jet4 but it can't
be opened in Access XP [2002]. To get around the problem I started making a
conversion in VB6 by creating a new Jet4 database then copying the database
structure and all the data using various DAO facilities. This tip 'builds
on' a the September 2000 tip: Dynamically Update a DAO Database Using a
Model. I added one more class which I call 'cCopyDataDAO.cls'. I wrote a VB6
demo program to show how to use the tip.

Link to the tip using:


Look for the December 2002 tip of the month.

Larry Rebich

More tips link to:

No personal e-mail questions :-)