Microsoft Access and the SCCI

[adam_cheney]

Hi there Access forum,

First up, a pre-emptive request to excuse me if I show my ignorance - I'm not really an Access user/developer, I'm a SCM person.

We have a team that develops Access dbs and they are looking to integrate better with ClearCase. At present, they use the UNIX client and transfer whole, binary Access dbs, then source-control the binary file. They would like to be able to integrate better - my understanding, from them, is that VSS will control individual tables/forms, etc. I assume this is because it integrates via the SCC interface.

I cannot find anything about the SCC interface in my Access tool (just part of the Office distribution handed out to all desktops here) apart from a reference to Office XP Developer.

Can anyone provide me with any more information (even if that is just to point me elsewhere)?

Using VSS is not an option, by the way - the SCM standards specify ClearCase or Subversion (which would access the SCC interface via the PushOK proxy).

Thanks in advance - Adam Cheney

 

[ksj]

Source Safe and Access

Hey Adam -

In Access 2007, the developer extensions are free and include the source safe interfaces. In Access 2003, there is an add-in.

http://www.microsoft.com/downloads/...f4-a916-48c5-8f84-44b91fa774bc&displaylang=en

I don't know that you'll find them extensible into ClearCase (although I think CC is a more intuitive tool than SCC). Maybe you will, though. And they're free, so that's a bonus.

K

 

[adam_cheney]

ksj - thank you so much.

As it happens, we're using: Access 2002 (10.4302.4219) SP-2.

If I can get the SCC interface working for our client (even if we need to upgrade it) then I should be able to use *any* tool that accesses the SCCI to perform any action that VSS can. I think that the SCCI for Access 2002 is only through XP developer, though - unless anyone knows different.

Cheers again - Adam...