Anything else like Sourcesafe that works with Access?

[Diarmuid]

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.
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

 

[david epsom dot com dot au]

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:
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)

 

[david epsom dot com dot au]

alternate source control plug in for cvs:
http://www.pushok.com/soft_short_info.php

(david)

 

[Vayse]

Thanks David, plenty for me to go on.

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:
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)