Is there an easy way to keep track of which modules I've worked with day by
day. I'd like to see a log of what items I "affected" - so that when a
database goes sour I can easily see what changed from the previous version
(my feeble mind can't retain all of this, especially when a week passses
before getting back to a project).
Is there a log mechanism within Access or is there some sort of support
software someone can recommend which would help me with this?
Thanks!
Andi 9 2021
On Tue, 20 Jan 2004 14:59:30 -0500 in comp.databases. ms-access,
"DBQueen" <ir******@bells outh.net> wrote: Is there an easy way to keep track of which modules I've worked with day by day. I'd like to see a log of what items I "affected" - so that when a database goes sour I can easily see what changed from the previous version (my feeble mind can't retain all of this, especially when a week passses before getting back to a project).
Is there a log mechanism within Access or is there some sort of support software someone can recommend which would help me with this?
There are many source code control programs around, e.g., StarTeam,
Perforce, Visual SourceSafe. Whichever you go for, you'll need the
Office developer edition in order to integrate with it.
--
A)bort, R)etry, I)nfluence with large hammer.
On Tue, 20 Jan 2004 22:12:58 +0000, Trevor Best <bouncer@localh ost> wrote: On Tue, 20 Jan 2004 14:59:30 -0500 in comp.databases. ms-access, "DBQueen" <ir******@bells outh.net> wrote:
Is there an easy way to keep track of which modules I've worked with day by day. I'd like to see a log of what items I "affected" - so that when a database goes sour I can easily see what changed from the previous version (my feeble mind can't retain all of this, especially when a week passses before getting back to a project).
Is there a log mechanism within Access or is there some sort of support software someone can recommend which would help me with this?
There are many source code control programs around, e.g., StarTeam, Perforce, Visual SourceSafe. Whichever you go for, you'll need the Office developer edition in order to integrate with it.
Personally, for the projects I work on which are usually only 1 to 3
developers, generally not working with shared same files on a daily basis, I
prefer the manual source code control method.
Since hard drives are now cheap, and copying files is fast, I simply don't do
any work on any day without first making a new folder named something like
"2004-01Jan-20", and copying everything from the previous day's folder into
it, then start from there. In any odd case where I'm about to make big
changes to existing code at some point in the day, I'll stop first, and make a
new working folder like "2004-01Jan-20_2", copy the files there, and keep
going.
After I have a -lot- of these, I'll start doing random culling of folders in
the middle the project history. If I ever need something form a specific date
that I deleted, I can grab it off a backup.
It works well, it's easy to use, it's obvious to other developers who have to
work on your project, and it's free if you don't count the cost of the drive
space (which is still very cheap).
I've used this method, too, on a number of projects, and it has worked well
for me. The largest development team involved on any of those projects was 6
developers (at least one of whom was mostly involved in managing the
project, working as server DBA, and not doing much actual Access
development, and another mostly doing testing).
They had previously used a now-defunct third-party source code control app
on one of those projects before the project leader determined that it was
full of bugs, and because it put the integrity of the application itself at
risk, worse than useless. In fact, in reporting some bugs to the vendor of
the source control software, he surprised them by reading their (Access 2.0)
code to them. No, he didn't take advantage of the "famous CopyObject flaw",
they just hadn't properly secured it.
Larry Linson
"DBQueen" <ir******@bells outh.net> wrote in message news:<5C******* ************@bi gnews5.bellsout h.net>... Is there an easy way to keep track of which modules I've worked with day by day. I'd like to see a log of what items I "affected" - so that when a database goes sour I can easily see what changed from the previous version (my feeble mind can't retain all of this, especially when a week passses before getting back to a project).
Is there a log mechanism within Access or is there some sort of support software someone can recommend which would help me with this?
Thanks!
Andi
See this thread... http://groups.google.com/groups?hl=e...ases.ms-access
Short answer - yes, if you have the right version of Access
(Developer).
There are a number of source control systems out there. If you purchase the
Office Developer Version you will receive Visual Source Safe with MS Access
(the last one I have is Office XP Developer, I don't know if 2003 has the
same products). In any case, you can keep modules in any form of version
control software by exporting to the Version Control (VC) of choice and
importing into your access system.
In the end the real thing you probably want to control is components that
perform specific functions and the ability the reuse them across
applications. Any VC can do this, Visual Source Safe, PVCS, Endeavor, ENVY,
etc.
--
*************** ***************
Fred Parker
Lynn Consulting Group, L.L.C. http://www.lynnconsultinggroup.com
*************** ***************
Thank you to all for your help with this. Since I am using Access2000, it
looks like I'll need to go with Total Access Detective - VSS doesn't go back
to my "archaic" version. If any of you have used it, are you generally
pleased with its functionality?. ..or heard any rumors to the contrary?
In general are the FMS products pretty solid? I'm thinking about purchasing
Analyzer as well.
Andi
"fp" <et************ ****@hotmail.co m> wrote in message
news:zy******** ***********@nwr ddc03.gnilink.n et... There are a number of source control systems out there. If you purchase
the Office Developer Version you will receive Visual Source Safe with MS
Access (the last one I have is Office XP Developer, I don't know if 2003 has the same products). In any case, you can keep modules in any form of version control software by exporting to the Version Control (VC) of choice and importing into your access system.
In the end the real thing you probably want to control is components that perform specific functions and the ability the reuse them across applications. Any VC can do this, Visual Source Safe, PVCS, Endeavor,
ENVY, etc.
-- *************** *************** Fred Parker Lynn Consulting Group, L.L.C. http://www.lynnconsultinggroup.com *************** ***************
There was a version of Visual Source Safe included in the Access 2000
Developer Edition, IIRC. You might be able to pick up a copy of A2K Dev.
Edition at one of the online auction sites.
Perhaps you mean that a more recent version of VSS doesn't handle Access
2000? That could be the case, but I was under the impression that VSS was
insensitive to the version of the products you used with it.
Larry Linson
Microsoft Access MVP
"Andi Plotsky" <ir******@bells outh.net> wrote in message
news:ZQ******** ********@bignew s3.bellsouth.ne t... Thank you to all for your help with this. Since I am using Access2000, it looks like I'll need to go with Total Access Detective - VSS doesn't go
back to my "archaic" version. If any of you have used it, are you generally pleased with its functionality?. ..or heard any rumors to the contrary?
In general are the FMS products pretty solid? I'm thinking about
purchasing Analyzer as well.
Andi "fp" <et************ ****@hotmail.co m> wrote in message news:zy******** ***********@nwr ddc03.gnilink.n et... There are a number of source control systems out there. If you purchase the Office Developer Version you will receive Visual Source Safe with MS Access (the last one I have is Office XP Developer, I don't know if 2003 has
the same products). In any case, you can keep modules in any form of version control software by exporting to the Version Control (VC) of choice and importing into your access system.
In the end the real thing you probably want to control is components
that perform specific functions and the ability the reuse them across applications. Any VC can do this, Visual Source Safe, PVCS, Endeavor, ENVY, etc.
-- *************** *************** Fred Parker Lynn Consulting Group, L.L.C. http://www.lynnconsultinggroup.com *************** ***************
According to the Microsoft website, it is available for .NET. The only
older version available from Microsoft says:
"Licensed users of Visual SourceSafe should get the Microsoft Office 97,
Developers Edition (ODE), which includes Microsoft Access 97 as well as the
integration files needed to take advantage of Visual SourceSafe."
Also, according to the Evaluator's Guide, the newest version of Access
listed is Access97. (However, this page is dated 2/2000.)
So I was concerned that it wouldn't work with Access2000.
It also mentioned that it was compatible with Win95 and WindowsNT
environments - but I have Win98 and XP running on my computers. I guess I
should check with Microsoft Sales to see if it is, in fact, compatible with
my system. I like your idea of getting an old copy of A2K Developer's
Edition - now that I'm not in school anymore and in the REAL world, I
suppose the time has come to upgrade to the REAL Developers' World :) Most
of my clients have Office2000, so I hesitate to upgrade everything and leave
them behind.
Thanks!
Andi
"Larry Linson" <bo*****@localh ost.not> wrote in message
news:Pz******** *******@nwrddc0 1.gnilink.net.. . There was a version of Visual Source Safe included in the Access 2000 Developer Edition, IIRC. You might be able to pick up a copy of A2K Dev. Edition at one of the online auction sites.
Perhaps you mean that a more recent version of VSS doesn't handle Access 2000? That could be the case, but I was under the impression that VSS was insensitive to the version of the products you used with it.
Larry Linson Microsoft Access MVP
"Andi Plotsky" <ir******@bells outh.net> wrote in message news:ZQ******** ********@bignew s3.bellsouth.ne t... Thank you to all for your help with this. Since I am using Access2000,
it looks like I'll need to go with Total Access Detective - VSS doesn't go back to my "archaic" version. If any of you have used it, are you generally pleased with its functionality?. ..or heard any rumors to the contrary?
In general are the FMS products pretty solid? I'm thinking about purchasing Analyzer as well.
Andi "fp" <et************ ****@hotmail.co m> wrote in message news:zy******** ***********@nwr ddc03.gnilink.n et... There are a number of source control systems out there. If you
purchase the Office Developer Version you will receive Visual Source Safe with MS Access (the last one I have is Office XP Developer, I don't know if 2003 has the same products). In any case, you can keep modules in any form of
version control software by exporting to the Version Control (VC) of choice
and importing into your access system.
In the end the real thing you probably want to control is components that perform specific functions and the ability the reuse them across applications. Any VC can do this, Visual Source Safe, PVCS, Endeavor,
ENVY, etc.
-- *************** *************** Fred Parker Lynn Consulting Group, L.L.C. http://www.lynnconsultinggroup.com *************** ***************
On Fri, 23 Jan 2004 17:43:00 -0500, "Andi Plotsky"
<ir******@bells outh.net> wrote: "Licensed users of Visual SourceSafe should get the Microsoft Office 97, Developers Edition (ODE), which includes Microsoft Access 97 as well as the integration files needed to take advantage of Visual SourceSafe."
I'm pretty sure the "integratio n files needed to take advantage of
Visual SourceSafe" do not include SourceSafe itself.
--
Mike Sherrill
Information Management Systems This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: JLuppens |
last post by:
Does anyone know if there
is a way to track changes in a text field like word does? I am using
a SQL2000 database and can use either VB.Net or Access. The field is
either ntext or Varchar. I would like to show users the changes
other users have made to a text field using a other font or font
color.
Thanks
|
by: Sandman |
last post by:
Just looking for suggestion on how to do this in my Web application.
The goal is to keep track of what a user has and hasn't read and present him or
her with new material
I am currently doing this by aggregating new content from all databases into a
single indexed database and then saving a timestamp in the account database
(for the current user) that tells me when the user last read items in the
aggregated database.
|
by: BarryS |
last post by:
Hi All:
We're rolling out 3 DB2 (8.2 on LUW) platforms for branch offices, each
of these are going to have the same schema. These are all going to be
non-federated systems.
I need some advice / pointers on keeping the DDL's in sync with each other.
I'm going to have a development machine in my office that I first apply
any schema / stored-procedure changes to, then would like to roll out
|
by: Joshua Russell |
last post by:
I'm writing some software that opens multiple instances of a single class in
new threads. I need a way of keeping track of all these class instances in
some kind of collection. I'm basicaly writing an MSN Messenger like
application. The threads being, in this case, the chat windows. I would like
to be able to access the various referances in a similar way to the
following if it can be done...
convoThreads.someFunctionInTheClass();
Has...
|
by: Alfred Taylor |
last post by:
I'm testing the waters of n-tier development and I ran into a scenario that
I'm not sure what the best solution would be. I have a Company object which
contains a collection of contacts retrieved from a database.
In the presentation layer, the user will be able to add/delete/modify this
collection in which case it needs to be synced with the database.
The question is basically how best to do this? Aside from overriding the
add/remove...
| |
by: Daniel Walzenbach |
last post by:
Hi,
I need to track all changes made to an object. Consider the following class:
Public Class Dog
|
by: metaperl |
last post by:
I'm actually taking Microsoft's 2779 and just finished a lab where we
kept track of our changes to the database.
However, I'm not happy with the scripts interface because it does not
tell me the chronological order of my changes to the database.
Could someone share with me their technique for keeping track of
database changes?
I'm actually thinking a set of tables would be best, because sometimes
|
by: De_Cisse |
last post by:
Hi all,
I'm working on an application in which I already make some
preparations to be able to work in a frontend and backend database,
even if this isn't the issue a this moment. I'm using VBA classes for
this (I know not the easiest way, but I have made some considerations
and I want to to it this way as VBA classes are some new stuff to
explore for me).
In a class 'client' I get the data from the database and put it in
|
by: dirksza2009 |
last post by:
Hi,
I've made a multi user (4 end users) database in Access 2000. I've made data tables, reference tables etc which sits on a shared drive and I've made individual front ends for the end users which gives them specific views of the data.
I'd like to track all the changes made to a record which works find with the following code :
basAuditTrail:
Option Compare Database
Const cDQ As String = """"
Sub AuditTrail(frm As Form, recordid As...
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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...
|
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...
|
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();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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
| |