[dba-SQLServer]Re: Visual Source Safe Questions

Charlotte Foust cfoust at infostatsystems.com
Fri Oct 24 17:47:21 CDT 2003


No, queries are separate objects.  Tables, references, relationaships,
toolbars, etc. are all stored in a misc data object file.

Charlotte Foust

-----Original Message-----
From: Bryan Carbonnell [mailto:carbonnb at sympatico.ca] 
Sent: Tuesday, October 21, 2003 2:19 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer]Re: Visual Source Safe Questions


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.


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com



More information about the dba-SQLServer mailing list