Anything else like Sourcesafe that works with Access?

I normally use Sourcesafe, for checking in my Access databases. Sometimes,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12580-anything-else-like-sourcesafe-works-access.html
I'd check in the whole database. On more complex projects, where I'm working
with other developers, I'd set up the Office Developer version, where you
can check in items (tables/queries/forms etc.) on their own.
However, I've just started a new position, and they have no source control
tools.
For now, something that would let me check in the whole database would do.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12580
Anyone using anything other than sourcesafe? Is there a some free source
control tool that people would recommend?

Thanks
Diarmuid

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Access has two hidden functions: LoadFromText SaveAsText.
These save forms, reports, queries, macro's as text.

Any version control system that can handle text can handle
Access forms, reports, queries.

The Access developers edition has an Access add in that
handles saving and loading the text files. The Addin connects
to a com interface in Source Safe

I think that the com interface is the same interface
used by VB. Several of the other commercial version control
systems apparently use the same interface. (PVCS? Star?)
AFAIK, there is no other integration interface available:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12580
you have to buy the developer kit from MS to get the integration
interface.

The SaveAsText interface cannot handle tables or permissions.
To track table or permission changes, you need to find
something else. There are some XML utilities out there
to help you

http://www.smithcomputing.com/monitor2000/benefits.html
Access monitor is a database system for tracking changes.

Also, the FMS and SSW products take snapshots and allow
you to compare databases, although I don't think either
company has an actual 'version control' system.

(david)


"Diarmuid" wrote in message
news:O4NqdZCoGHA.608@TK2MSFTNGP02.phx.gbl...
>I normally use Sourcesafe, for checking in my Access databases. Sometimes,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12580
>I'd check in the whole database. On more complex projects, where I'm
>working with other developers, I'd set up the Office Developer version,
>where you can check in items (tables/queries/forms etc.) on their own.
> However, I've just started a new position, and they have no source control
> tools.
> For now, something that would let me check in the whole database would do.
> Anyone using anything other than sourcesafe? Is there a some free source
> control tool that people would recommend?
>
> Thanks
> Diarmuid
>

alternate source control plug in for cvs:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12580
http://www.pushok.com/soft_short_info.php

(david)

"Diarmuid" wrote in message
news:O4NqdZCoGHA.608@TK2MSFTNGP02.phx.gbl...
>I normally use Sourcesafe, for checking in my Access databases. Sometimes,
>I'd check in the whole database. On more complex projects, where I'm
>working with other developers, I'd set up the Office Developer version,
>where you can check in items (tables/queries/forms etc.) on their own.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12580
> However, I've just started a new position, and they have no source control
> tools.
> For now, something that would let me check in the whole database would do.
> Anyone using anything other than sourcesafe? Is there a some free source
> control tool that people would recommend?
>
> Thanks
> Diarmuid
>

Thanks David, plenty for me to go on.

"david epsom dot com dot au" wrote in message
news:Oqk%2392CoGHA.1076@TK2MSFTNGP03.phx.gbl...
> Access has two hidden functions: LoadFromText SaveAsText.
> These save forms, reports, queries, macro's as text.
>
> Any version control system that can handle text can handle
> Access forms, reports, queries.
>
> The Access developers edition has an Access add in that
> handles saving and loading the text files. The Addin connects
> to a com interface in Source Safe
>
> I think that the com interface is the same interface
> used by VB. Several of the other commercial version control
> systems apparently use the same interface. (PVCS? Star?)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12580
> AFAIK, there is no other integration interface available:
> you have to buy the developer kit from MS to get the integration
> interface.
>
> The SaveAsText interface cannot handle tables or permissions.
> To track table or permission changes, you need to find
> something else. There are some XML utilities out there
> to help you
>
> http://www.smithcomputing.com/monitor2000/benefits.html
> Access monitor is a database system for tracking changes.
>
> Also, the FMS and SSW products take snapshots and allow
> you to compare databases, although I don't think either
> company has an actual 'version control' system.
>
> (david)
>
>
> "Diarmuid" wrote in message
> news:O4NqdZCoGHA.608@TK2MSFTNGP02.phx.gbl...
>>I normally use Sourcesafe, for checking in my Access databases. Sometimes,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12580
>>I'd check in the whole database. On more complex projects, where I'm
>>working with other developers, I'd set up the Office Developer version,
>>where you can check in items (tables/queries/forms etc.) on their own.
>> However, I've just started a new position, and they have no source
>> control tools.
>> For now, something that would let me check in the whole database would
>> do.
>> Anyone using anything other than sourcesafe? Is there a some free source
>> control tool that people would recommend?
>>
>> Thanks
>> Diarmuid
>>
>
>