Robert L. Stewart
rl_stewart at highstream.net
Tue Oct 21 15:07:43 CDT 2003
Susan, I can not address #1. 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. Having said that, there are some hidden methods of the application object that allows you to save things like a form to a text file and bring it back in later to recreate the form. So, you could store that text file in VSS. The same is true for queries and their SQL statement as well as modules. Not sure about reports, but I will let you know. I don't see a way of doing it with a macro, but I will check it out also. You would have to write code to export the objects and then use VSS to manage them. Robert At 12:00 PM 10/21/2003 -0500, you wrote: >Date: Mon, 20 Oct 2003 12:42:01 -0500 >From: "Susan Geller" <sgeller at cce.umn.edu> >Subject: [dba-SQLServer]Visual Source Safe Questions >To: <dba-SQLServer at databaseadvisors.com> >Message-ID: > <CD6E25A7E2F6734FA126AED83B9D54FB01C75173 at ccemail2.cce.local> >Content-Type: text/plain; charset="us-ascii" > >We recently bought Visual Source Safe are just starting to use it. A >couple of questions: > >1. Is anybody using mssqlXpress? Visual Source Safe integrates so >smoothly with .NET, but working with ADP's and SQL Server is less >smooth. Is anybody using this tool -- from their website it looks to me >that it makes VSS and SQL Server work better together. >http://www.mssqlxpress.com/Home.shtm > >2. With VSS, can you check in/out only a single part of an ADP, such as >a single form or report? If so, how? > >Thanks. > >--Susan