473,657 Members | 2,721 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Subversion and splitting apart MDB files for better version control in VBA for Access?

My company I work for uses VBA for Access to program one of our
projects. We just now set up the Subversion version control system for
our various projects.

It works great for our VB6 and .NET work, of course, but our main
program is still in old VBA, all of the front-end code is in one
database file. Not only does it take a while to commit changes to the
repository, but it also somewhat defeats the purpose of the using SVN,
since we probably would have to manually merge every change we make if
more than one person decides to work on the code.

Is there any way that we could break up the code? Is there a command of
some sort in Access where you can take all of the forms, modules, etc
out of the MDB file into the same folder to store in the repository? Or
is there any other good way to handle the situation? If anyone knows
the best way to split the database up to better handle version control,
it would be very helpful.

Shawn Axsom

Jul 18 '06 #1
1 4550
We use Visual Source Safe for version control for MS Access. Works
fine, though it's a pain in the a&&, as I assume all version control
is.

Jeremy Wallace
Fund for the City of New York

axs221 wrote:
My company I work for uses VBA for Access to program one of our
projects. We just now set up the Subversion version control system for
our various projects.

It works great for our VB6 and .NET work, of course, but our main
program is still in old VBA, all of the front-end code is in one
database file. Not only does it take a while to commit changes to the
repository, but it also somewhat defeats the purpose of the using SVN,
since we probably would have to manually merge every change we make if
more than one person decides to work on the code.

Is there any way that we could break up the code? Is there a command of
some sort in Access where you can take all of the forms, modules, etc
out of the MDB file into the same folder to store in the repository? Or
is there any other good way to handle the situation? If anyone knows
the best way to split the database up to better handle version control,
it would be very helpful.

Shawn Axsom
Jul 18 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
1386
by: Eric Mathew Hopper | last post by:
I have a patch that allows pydoc to deal with Subversion (http://www.subversion.tigris.org) style version strings. Subversion does not do '$Revsion: num$' style tags. The closest it will get is '$Rev: num$'. So, I included a check for that type as well. It's a patch to this version of pydoc.py __version__ = "$Revision: 1.86.8.1 $"
17
8630
by: Lonnie Princehouse | last post by:
In short: Is there any way to run Python WITHOUT trying to create .pyc files (or ..pyo) or to have Python not attempt to import the .pyc files it finds? Reason: We have a site-specific package installed on a network drive. When anyone with write access imports this package, the network drive gets spammed with .pyc files.
1
2929
by: Arthur Chereau | last post by:
Hi, I'm trying to setup viewcvs to work with subversion 1.2.0 on Linux with Python 2.4.1. The last viewcvs (from CVS) needs subversion python bindings. I installed swig and built subversion from source with it. Everything works fine until I try to build the Python bindings. When I try "make swig-py" I get the following, Python related, error: # make swig-py
19
4088
by: James Fortune | last post by:
I have a lot of respect for David Fenton and Allen Browne, but I don't understand why people who know how to write code to completely replace a front end do not write something that will automate the code that implements managing unbound controls on forms given the superior performance of unbound controls in a client/server environment. I can easily understand a newbie using bound controls or someone with a tight deadline. I guess I need...
5
1285
by: Peter Oliphant | last post by:
I was thinking it might be a good idea to split this newsgroup into different newsgroups, depending on the version of VS C++.NET being discussed. Thus, there would be 2002, 2003, and 2005 newsgroups instead of just one for all. This would at least end any confusion if someone asks a question and doesn't state which version they are using (which of course can change the answer to such questions). Just a thought...
3
3196
by: patkinson | last post by:
Hello, I am one of those guys trying with no chance to get a working copy of TRAC for python 2.5 http://trac.edgewall.org/ is a superb Project managment tool with a wiki, control version (SVN), and a tracking bug/task system. This is a suposed place to go for a windows user: http://trac.edgewall.org/wiki/TracOnWindows/Python2.5
3
2010
by: salad | last post by:
I have an A97 application that is NOT split on a network. It is used by 15+ folks continually. It is quick and fast. I split it several years ago and had to merge it together again after the folks rebelled at the slow speed resulting from the split. I have to bite the bullet and split it now. Of course, it is much slower. In one form that opens as a continous form, the data looks like it is being repainted as it displays...you can...
9
5996
by: =?windows-1252?Q?=22=C1lvaro_G=2E_Vicario=22?= | last post by:
I’ve been using Subversion for a while to maintain the PHP web apps and sites I develop in my Windows box. But when I want to publish a new release I update the live site manually and I want to improve this process. I can’t simply export to a fresh directory and upload all files because that won’t handle renames and deletions (and the upload will take forever anyway). I typically use WinMerge to find out what files changed but there’re...
0
6602
nathj
by: nathj | last post by:
Hi, While I know this is not strictly a Java issue I thought this would be the place to post as I know a lot of Java developers use Eclipse and most likely use SVN and Subclipse. First up here's the error message I receive: RA layer request failed svn: Server sent unexpected return value (403 Forbidden) in response to OPTIONS request for 'http://10.1.211.2/svn'
0
8382
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8600
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7311
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6162
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5629
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4150
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2726
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1930
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1600
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.