[dba-SQLServer]Re: Visual Source Safe Questions

Robert L. Stewart rl_stewart at highstream.net
Wed Oct 22 14:19:01 CDT 2003


Bryan,

On the other list she asked about an ADP not an MDB.

I posted the code that would allow her to save any
of the Access objects as a text file and place them
in VSS.

Robert

At 12:00 PM 10/22/2003 -0500, you wrote:
>Date: Tue, 21 Oct 2003 18:18:54 -0400
>From: "Bryan Carbonnell" <carbonnb at sympatico.ca>
>Subject: Re: [dba-SQLServer]Re: Visual Source Safe Questions
>To: dba-sqlserver at databaseadvisors.com
>Message-ID: <3F95788E.23795.11EB0B8 at localhost>
>Content-Type: text/plain; charset=US-ASCII
>
>On 21 Oct 2003 at 15:07, Robert L. Stewart wrote:
>
> > But, #2, the answer is no.  Because Access stores things as objects,
> > you cannot checkin/checkout individual objects with a tool like VSS.
> > What you would need is an Access database to do it.  I used to use a
> > tool called Version Manager that was an add-in written in Access.  But
> > I have not been able to find an updated version of it from the creator
> > of it.
>
>Actually, with a regular MDB you can. IIRC for tables and queries
>it's an all or nothing proposition, but with forms, reports and code
>modules you can check in/out the individual components.
>
>All this assumes you have The Developer's tools and have installed
>the VSS Access Integration bits.
>
>I know Charlotte uses(used) VSS quite a lot with Access, so you may
>get a better response on VSS and Access over on AccessD.
>
>--
>Bryan Carbonnell - carbonnb at sympatico.ca
>I've learned....
>That to ignore the facts does not change the facts.




More information about the dba-SQLServer mailing list