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