Convert Access 2.0 MDB to Access95 MDB? 
Author Message
 Convert Access 2.0 MDB to Access95 MDB?


>I need to create a VB app that periodically converts an Access 2.0 database
>to an Access95 database. It doesn't appear that VB5's Compact method will
>work (according to both the Help file and the examples I've tried).

It should be able to physically convert the database, but it won't
correctly update any Access 2.0 module code to valid Access 95 module
code. The tables and queries should be converted however.

Here's an example:

dbengine.CompactDatabase "c:\access\sampapps\nwind.mdb",
"c:\temp\nwindc.mdb", , dbVersion30

-- Jim Ferguson, FMS

Wed, 29 Sep 1999 03:00:00 GMT  
 Convert Access 2.0 MDB to Access95 MDB?


>When you do this conversion and then try to open the database in Access 97,
>it gives an error that the database was converted using DAO.ConvertDatabase
>and that it cannot be opened until the tables and queries are imported.  

I was not aware of that.

>Is there any way to avoid this if there are not other objects in the database?

I'm not sure.

-- Jim Ferguson, FMS

Fri, 01 Oct 1999 03:00:00 GMT  
 [ 2 post ] 

 Relevant Pages 

1. convert Access 2.0 .mdb to Visual Basic .exe

2. Convert Access97.mdb to Access95?

3. TransferDatabase method from Access 95 mdb to Access 97 mdb

4. Convert JET 1.1 to 2.0 MDB

5. Convert JET 1.1 to 2.0 MDB

6. Help: Problem reading Access 2.0 mdb from VB3 under Win95/Access 7.0

7. Automatic conservion or importing to Access 97 from Access 2.0 MDB

8. Procedures for Converting an Access 97 MDB to Access 2002

9. Access 2.0, 7.0 and VB5, One program to open any MDB

10. Program fragments in Access 2.0 mdb files

11. Creating/Modifying MDB objects in Access 2.0 / Jet 2.5 Format

12. VB3.0 + Access 2.0 MDB?


Powered by phpBB® Forum Software