Microsoft KB Archive/287460

= ACC2002: Cannot Import Data After You Add Database to Visual SourceSafe =

Article ID: 287460

Article Last Modified on 10/20/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



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.



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.

Additional query words: pra import external sourcesafe vss can't can not

Keywords: kberrmsg kbbug kbnofix KB287460

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.