VB & Database, Convert Access 2.0 MDB to Access95 MDB?

Convert Access 2.0 MDB to Access95 MDB?

Author	Message
Jim Fergus #1 / 2	Convert Access 2.0 MDB to Access95 MDB? Steven, Quote: >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 http://www.--*.com/
Wed, 29 Sep 1999 03:00:00 GMT

Jim Fergus #2 / 2	Convert Access 2.0 MDB to Access95 MDB? Issie, Quote: >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. Quote: >Is there any way to avoid this if there are not other objects in the database? I'm not sure. -- Jim Ferguson, FMS http://www.fmsinc.com
Fri, 01 Oct 1999 03:00:00 GMT

Page 1 of 1

[ 2 post ]