SourceSafe and VBA Access

[Phantazmo]

Folks,

I have a job shop management database that I would like to tie in with a SourceSafe database. ie. SourceSafe currently vaults thousands of NC program for CNC lathes and mills, and I would like to update item records within the Access 97 database to reflect current code revisions.

Does anyone have an experience with Visual Source Safe's database structure (VSS6.0D)

tia,

 

[VBslammer]

What are you trying to do with VSS, automate it using OLE? The VSS object model is somewhat difficult to figure out, but MSDN does have a white paper describing how to automate it that is fairly thorough. See it here.

There is also a VB example program available for download that does everything the full version of VSS does (includes an ocx control for tasks not exposed via OLE). If you have the full version of VB you can load it and see how each task is performed using vb:

Source Safe OLE Example

VBSlammer

"You just have to know which screws to turn." - Professor Bob