|
|
Title | Convert an Access database to Access2002 |
Description | This example shows how to convert an Access database to Access2002 in Visual Basic 6. |
Keywords | Access, Office, Microsoft Office, MS Office, convert |
Categories | Office, Database |
|
|
Select Project\References and add a reference to Microsoft Access 10.0 Object Library. Create an Access.Application object and use its ConvertAccessProject method to convert the database to a new version.
|
|
Private Sub cmdConvert_Click()
Dim app As Access.Application
Set app = New Access.Application
app.ConvertAccessProject txtSource.Text, txtDest.Text, _
acFileFormatAccess2002
MsgBox "Done"
End Sub
|
|
|
|
|
|