Sunday, January 16, 2011

MSAccess SVN

Project Description

Access SVN adds to Microsoft Access (MS Access) support for SVN Source control

What is MS Access SVN

MS Access SVN its a tool to integrate MS Access solutions with svn source control.
An MS Access solution is compound by any of the following components:

  • VBA code in modules and classes
  • Forms: design and VBA code
  • Reports: design and VBA code
  • Queries: Query definition. Only for mdb files
  • Macros
  • Access Pages
  • Tables: only for mdb file format
  • Database properties
  • Database properties, including startup form options
  • Table relations: only for mdb files
  • References: References to other libraries or MS Access files

MS Access SVN will support the following file formats
  • mdb: Classic file format
  • adp: Access projects: in this files, queries and tables are stored in a sql server database, wich has tools enought to export and create sql scripts.
  • accdb: New file format for Access 2007 and following

Read more: Codeplex