ACC2002: Tables Copied and Pasted in a Microsoft Access Database or Project Do Not Retain Permissions (295187)


The information in this article applies to:

  • Microsoft Access 2002
This article was previously published under Q295187
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 copy and paste a table in a Microsoft Access database (.mdb) or an Access project (.adp), the new table does not include permissions from the original table.

RESOLUTION

Assign permissions manually in the new table.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Install the NorthwindCS sample project to your SQL Server.
  2. Open NorthwindCS in Enterprise Manager.
  3. Right-click the Customers table, and then click Properties.
  4. In the table property sheet, click Permissions, and note that there are permissions set for the table.
  5. Open NorthwindCS in Microsoft Access.
  6. Copy and paste the Customers table.
  7. Return to Enterprise Manager, and note that there are no permissions set.

REFERENCES

For additional information about a related issue, click the article number below to view the article in the Microsoft Knowledge Base:

287494 ACC2002: When You Paste Table Structure in ADP, Extended Properties Are Not Included in New Table

Modification Type:MajorLast Reviewed:10/20/2003
Keywords:kbprb KB295187
©2003 Microsoft Corporation. All rights reserved.