DOCUMENT:Q163348  15-NOV-2000  [ssafe]
TITLE   :ACC97: Tables That Appear to Be Checked In in VSS Are Not
PRODUCT :Microsoft SourceSafe
PROD/VER:97
OPER/SYS:
KEYWORDS:kbinterop

======================================================================
-------------------------------------------------------------------------------
The information in this article applies to:

 - Microsoft Access 97 
-------------------------------------------------------------------------------

SYMPTOMS
========

Advanced: Requires expert coding, interoperability, and multiuser skills.

Tables that you create with macros, Visual Basic code, or make-table queries
appear to be checked in. They display the Checked In glyph, or icon, but they
are not a part of the SourceSafe project. When you get the latest version from
SourceSafe, or check out Data and Misc. Objects, the tables are deleted. Also,
you cannot check the tables in or add them to the SourceSafe project.

This article assumes that you are familiar with using the client-side
capabilities of Visual SourceSafe. For more information about Visual SourceSafe,
please refer to the "Visual SourceSafe User's Guide" or Help topics available
from the Visual SourceSafe Help menu.

CAUSE
=====

You did not have Data and Misc. Objects checked out when you created the tables.

RESOLUTION
==========

Before you create a table with macros, Visual Basic code, or make-table queries,
be sure you check out Data and Misc. Objects. Then when you create your new
tables, they will be saved with the SourceSafe project.

STATUS
======

This behavior is by design.

MORE INFORMATION
================

Steps to Reproduce Behavior
---------------------------

1. Create a new database and add it to SourceSafe control.

2. Create the following new macro:

         Macro Name      Action
         --------------------------------
         CreateTable     TransferDatabase

         CreateTable  Actions
         -----------------------------------------
         TransferDatabase
            Transfer Type: Import
            Database Type: Microsoft Access
            Database Name: <Path to Northwind.mdb>
            Object Type: Table
            Source: Employees
            Destination: tblTest
            Structure Only: No

3. Save the CreateTable macro, and add it to SourceSafe control when prompted.

4. Run the CreateTable macro. The table tblTest is created, and it shows the
   SourceSafe glyph that the table is checked into SourceSafe.

5. On the Tools menu, point to SourceSafe, and click Get Latest Version. Select
   Data and Misc. Objects, and then click OK. Note that when this is finished,
   the tblTest table is no longer in your database.

REFERENCES
==========

For more information about Source Code Control, search the Help Index for
"Source Code Control," or refer to the Source Code Control White Paper included
with Microsoft Office 97 Developer Edition Tools.

Additional query words: ACCSCC VSS SCC

======================================================================
Keywords          : kbinterop 
Technology        : kbAccessSearch kbAccess97 kbAccess97Search
Version           : 97
Hardware          : x86
Issue type        : kbprb

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS
PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND.  MICROSOFT DISCLAIMS
ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES
OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  IN NO
EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR
ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL,
CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF
MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.  SOME STATES DO NOT ALLOW THE EXCLUSION
OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES
SO THE FOREGOING LIMITATION MAY NOT APPLY.

Copyright Microsoft Corporation 2000.