What do Access developers user for code configuration management?

[Billy Smith]

I'm going to be making some major modifications to
an existing Access database (.mdb). Being a programmer,
I'm used to using some sort of software configuration
management tool for any source code changes I make.
Given that Access objects and code are kept inside
the .mdb file, it seems unlikely that the config
management tools I know of will work with Access.

I've searched for this topic in a few
microsoft.public.access groups but found nothing
useful.

What do Access developers use for config management
to keep code changes under control?

Thanks,
Billy G.

 

[Arvin Meyer [MVP]]

We use the VBA IDE. Many of us also use MZTools:

http://www.mztools.com/index.htm

These are free, oustanding addins for both VB and VBA. I also sometimes keep
a database of the code in each form and module in a TreePad text file:

http://www.treepad.com/
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[david epsom dot com dot au]

What do Access developers use for config management

http://www.codekabinett.com/rdumps.php?targetDoc=ScmAcc&Lang=2

In practice, a lot of Access development is single-user,
so all you need to do is make back up copies, and keep
notes. The database is a good place to keep notes.

Historically, all objects in the database used to be
tagged with the modification date and time. MS killed
that feature, but it still works for queries.

(david)

 

[Albert D. Kallal]

What do Access developers use for config management
to keep code changes under control?

The standard VSS (visual source safe) tools from micorsoft work just fine
with ms-access.

After all, most systems just transfer the file (form, code module, rerpot)
from your machine to the source code database. The fact that a form in not a
seperate file (like in VB6) really don't change the basic concpet of how
Source Code contorl generally works).

What is most interesting here is that VSS also works with your sql queries
(that is really neat, since you can check out quires...something you don't
get with sql server, or when using VSS with visual basic for example).

and, the ms-access ui will display objects checked in, and out.

In the following screen shots you an see a little lock, or check box beside
items I checked in, and out....

http://www.members.shaw.ca/Albertkallal/vss/index.htm