What do Access developers user for code configuration management?

  • Thread starter Thread starter Billy Smith
  • Start date Start date
B

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.
 
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)
 
What do Access developers use for config management
to keep code changes under control?
Click to expand...

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
 
Back
Top