ACC2002: Cannot Import Data After You Add Database to Visual SourceSafe (287460)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q287460
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you import any type of data into a database that you previously added to Microsoft Visual SourceSafe control, you receive the following error message:
Microsoft Access

To import tables, relationships, menus, toolbars, import/export specs or data access pages you must have the Data and Misc. Objects checked out.

CAUSE

For a database under Visual SourceSafe control, you must check out the data from the database before you can import data.

RESOLUTION

Before you try to import data, check out the objects from the database. To do so, follow these steps:
  1. On the Tools menu, point to SourceSafe, and then click Check out.
  2. In the Check Out Objects from SourceSafe dialog box, select all database objects, and then click OK.
  3. On the File menu, point to Get External Data, and then click Import.
You can now import data without receiving the error message.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. On a computer that has Access 2002 installed, install Visual Sourcesafe.
  2. In Access 2002, open the sample project NorthwindCS.adp.
  3. On the Tools menu, point to SourceSafe, and then click Add Database to SourceSafe. When you are prompted, close the database.
  4. In the Add to SourceSafe Project dialog box, click OK. If the Visual SourceSafe project does not already exist for this database, create it.
  5. In the Add Objects to SourceSafe dialog box, select all database objects, and then click OK.
  6. On the File menu, point to Get External Data, and then click Import. Note that you receive the error message that is mentioned at the beginning of this article.
Modification Type:MajorLast Reviewed:10/20/2003
Keywords:kbbug kberrmsg kbnofix KB287460
©2003 Microsoft Corporation. All rights reserved.