Command line /convert

  • Thread starter Thread starter Jon
  • Start date Start date
J

Jon

Apparently, if you open Access 2000 with the command line "/convert TARGET
DATABASE" it will convert from an earlier version to Access 2000.

Is there a command line for converting from Access 2000 to Access 97?

Dave
 
Not that I know of, but you can compact a database into an earlier version:

Look in the VisualBasic (not Access) help files by opening any module and
going to help. Look for the ComapctDatabase Method, then look for the DAO
(not JRO) example. It will give you the exact code you need to run. Keep in
mind, that however you run it, it will not automatically open the new
database in the different version. You'll need to shell out to a starter in
the right version, or run code that will quit the current version and start
the new one.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Are you saying that I can create a Visual Basic program that can Convert the
database to an ealier version? I don't actually need to open the converted
database. Converting alone is enough for my purposes.

Thank you for your advice.

Jon
 
Jon said:
Are you saying that I can create a Visual Basic program that can Convert the
database to an ealier version? I don't actually need to open the converted
database. Converting alone is enough for my purposes.
Click to expand...

Yes. The code in one database can convert/compact another. To convert to
Access 97:

DBEngine.CompactDatabase "olddb.mdb", "newdb.mdb", , dbVersion30
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top