Ann: Copy Database with Data Using DAO - December 2002 Tip of the Month
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 . 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.
More tips link to:
No personal e-mail questions :-)
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL