Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Anything else like Sourcesafe that works with Access?

Discussion in 'Information Technology' started by Diarmuid, Jul 28, 2006.

  1. Diarmuid

    Diarmuid
    Expand Collapse
    Guest

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

    Similar Threads Forum Date
    Try anything once, Chazji here I come! Blogs Oct 17, 2015
    Islam Ask anything about Islam? Interfaith Dialogues Nov 22, 2013
    Judaism Ask A Rabbi Anything! Interfaith Dialogues Oct 31, 2011
    Does Anything Trump God's Justice? Interfaith Dialogues Feb 6, 2011
    Who You Are Speaks Louder than Anything You Can Say Inspirational Stories Apr 16, 2005

  3. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

    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)


    "Diarmuid" <vayse@deadspam.com> 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.
    > 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
    >
     
  4. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

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

    (david)

    "Diarmuid" <vayse@deadspam.com> 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.
    > 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
    >
     
  5. Vayse

    Vayse
    Expand Collapse
    Guest

    Thanks David, plenty for me to go on.

    "david epsom dot com dot au" <david@epsomdotcomdotau> 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?)
    > 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" <vayse@deadspam.com> 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.
    >> 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
    >>

    >
    >
     

Share This Page