Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to programmatically convert multiple Access databases in Access 2002
Article ID: 304318 - View products that this article applies to.
This article was previously published under Q304318
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.mdb).
This article shows you two methods that you can use to programmatically convert Microsoft Access databases. The first method uses the ConvertAccessProject method to convert databases to the format that you specify. The second method uses the Shell function to run Msaccess.exe with the /convert switch. This second method is embedded in a comment block in the sample code. When you use the second method, the databases will be converted to Access 2000 file format regardless of the Default File Format that is specified in the Options dialog box on the Tools menu.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements.
For more information about the ConvertAccessProject method, in the Visual Basic Editor, click Microsoft Visual Basic Help on the Help menu, type convertaccessproject in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
For additional information about database conversion, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/319400/ )Conversion white paper is available in the download center