Joe Delphi said:
Hi,
Can MS Access 2002 be integrated with the latest version of VSS?
Yes, but you need the developers edition of access 2002.
For access 2003, you can simply download the add in here:
http://msdn.microsoft.com/office/understanding/access/tools/default.aspx
I have no idea why the VSS add in for 2002 ships with the developer edition,
but for a2003..it is a simple download, and does not requite the developers
edition.
By "integrated" I mean that I would expect to see menu buttons on
my
Microsoft Access pull-down menus for checking source code in and out of
VSS.
Yes, the integration is even better then he above. All you have to do is try
to open a form, or report or whatever in design mode. At that point your are
then prompted to check out the form (or whatever it was you are about to
open in design mode). So, you don't have to use a special menu etc. (you do
get a VSS menu bar, and some additional options that do appear in the
ms-access menus however. As a rule, you don't need those additional options
as attempting to open somthing in desginem more will prompt you. However,
you do get addiotnal right click options on a form etc, and can choose
check-in/ checkout options if you need to. And, so, if you delete a form, or
whatever, you can un-do you check out and pull back in the previous copy.
Also, can VSS track the versions of objects within an .mdb file or
is it limited to the .mdb file as a whole?
Yes...it tracks each object.
It versions of each object within the database. Even the queries in the
query builder can be checked in/out. So, down to the same objects you can
view in each of the design tabs (form level, query level, module level
etc.).
Here is a quick screen shot of a2003 with the VSS add in.
http://www.members.shaw.ca/AlbertKallal/vss/index.htm
Note how any objects I have checked out have a check mark beside the object.
And, any object that has not been check out by me has a 'lock' beside the
object.
