版本控制Access 2007数据库和应用程序 [英] Version control Access 2007 database and application

问题描述

我需要对Microsoft Access 2007数据库和应用程序进行版本控制。

I need to version control a Microsoft Access 2007 database and application. Currently everything is contained in a single mdb file.

应用程序包括：

• 表单


• VBA代码


• 实际数据库

我想我需要将数据库与窗体/代码分开。我想能够版本控制表单/代码作为文本支持版本差异。

I would assume I need to separate the database from the forms/code. I would like to be able to version control the forms/code as text to support version diffs.

目前我没有访问SourceSafe（我听说过可能是一些访问支持），所以我宁愿一个解决方案，将使用subversion或git。

At the moment I don't have access to SourceSafe (I heard there may be some access support) so I would prefer a solution that would work with subversion or git.

推荐答案

Access 2007有一个功能您可以在其中将数据库拆分为其表/查询（后端）和表单/报告（前端）。因为你的问题只提到控制表单和模块的版本，这可能是一个更优雅的解决方案。我不知道模块在分割后到哪里，所以这可能是一个绊脚石。

Access 2007 has a feature where you can split a DB into its Tables/Queries (backend) and Forms/Reports (front-end). Since your question mentions only version controlling the forms and modules, this might be a more elegant solution. I don't know where modules go after the split, so that might be a stumbling block.

Microsoft提供，这将允许您在VS中开发和运行版本控制通过任何VS插件（CVS / SVN / VSS /等）。

Microsoft offers VSTO (Visual Studio Tools for Office), which will let you develop in VS and run version control via any VS plugin (CVS/SVN/VSS/etc.).

最后，您可以直接连接到Visual Source Safe。 此MSKB文章有一些很好的信息和背景，而此在线办公文章旨在让您

Finally, you can just directly connect to Visual Source Safe. This MSKB article has some good information and background to go through, while this Office Online article is designed for getting you up and running.

最后，如果可能，我建议不要将代码从Access中取出。假设VBA编辑器是您的主要开发环境，您将在开发过程中添加额外的步骤，这不容易自动化。您所做的每个更改都需要手动导出，差异化和存储，并且没有Application.OnCompile事件可用于导出更改。甚至更严格，你必须手动导入来自其他开发人员的所有更改的源文件，当他们做签到。

Ultimately, I would suggest against taking the code out of Access if at all possible. Assuming the VBA editor is your primary development environment, you'll be adding extra steps to your development process that cannot easily be automated. Every change you make will need to be manually exported, diff'd, and stored, and there is no Application.OnCompile event that you could use to export the changes. Even tougher, you'll have to manually import all changed source files from other developers when they do checkins.

这篇关于版本控制Access 2007数据库和应用程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！