Home  Fees/Services  Access Examples  Tutorials  Access Download  Articles  Search  Contact  Privacy  Links
Application Object Examples
Convert Access Project VBA Example

Visual Basic Application Objects

 





Access Error
AddToFavorites
BuildCriteria
CloseCurrentDatabase
CodeDB
CompactRepair
ConvertAccessProject


Access ConvertAccessProject Method Example

Convert Access Project Method - Converts the specified Microsoft Access file from one version to another Access version.
Application.ConvertAccessProject(SourceFilename, DestinationFilename, DestinationFileFormat)

Where:

SourceFileName is the name of the Access database to convert. If a path is not specified the current directory will be assumed.

DestinationFilename The name of the file where Access saves the converted file. If no path then the current directory is assumed.



Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. The number of users supported depends on the transaction load and the amount of data but generally we recommend a limit of 10 to 15 users.

We create databases large and small. Some of our databases help run entire small businesses including travel agencies and airline reservation systems. We also handle unique businesses such as fly rod manufacturing. Did you know there are 11 steps in the making of a fly rod?


DestinationFileFormat Required AcFileFormat. The Access version of the converted file.  Valid entries are:

  • acFileFormatAccess2

  • acFileFormatAccess95

  • acFileFormatAccess97

  • acFileFormatAccess2000

  • acFileFormatAccess2002

  • acFileFormatAccess2003

Application.ConvertAccessProject("c:\mydbs\mydb_2000.mdb", & _
"c:\mydbs\mydb_2002.mdb",acFileFormatAccess2002








A Blue Claw Database Design Article:

Cloud-Based Access Database
 





Blue Claw Database Design Downloadable Tutorial:
Programming Crosstab Query Example  





A Blue Claw Software Design Template:

Preventive Maintenance (PM) Access Template
 



Contact Information

Copyright 2000-2017 Blue Claw Database Design