ACC2000: Table Created by User in Db_owner Role Makes User the Owner (253180)


The information in this article applies to:

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

This article applies only to a Microsoft Access project (.adp).

SYMPTOMS

In a Microsoft Access project, if you are logged on with a logon name that is not the database owner, but with a name that is a member of the built-in role db_owner, a table created by that user is owned by that user. The table is not owned by the dbo (database owner).

RESOLUTION

To resolve this problem, obtain Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a).

To obtain SR-1/SR-1a, click the article number below to view the article in the Microsoft Knowledge Base:

245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)

STATUS

Microsoft has confirmed that this is a problem in Access. This problem was corrected in Microsoft Office 2000 SR-1/SR-1a.

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample Access project NorthwindCS.adp.
  2. On the Tools menu, point to Security, and then click Database Security.
  3. At the Server Logins tab, click Add.
  4. Add a new user with the logon name of MrTest.
  5. Click SQL Server authentication, and then enter a password of MrTest. Click OK.
  6. Click the Database Users tab, and then add MrTest.
  7. Click the Database Roles tab, click db_owner, and then click Edit.
  8. Add MrTest to the role, and then click OK to close the dialog box.
  9. On the File menu, click Connection. Make a note of the current user name.
  10. Change the logon name to MrTest, click to clear the Blank Password check box, type the password MrTest, and then click OK. MrTest is now logged on.
  11. Click Tables, and then click New
  12. In the Choose Name dialog box, type the table name Test1, and then click OK.
  13. Define one or more fields in the Table1 table with any properties that you want, and then save and close the table. It does not matter whether or not you define a primary key.

    Note that each table has (dbo) beside it, except for the Table1 table. This indicates that MrTest is the owner of that table.
  14. On the File menu, click Connection.
  15. Change the logon information back to the original user name and password, and then click OK.
Note that the Test1 table has (MrTest) beside it.
Modification Type:MinorLast Reviewed:1/26/2005
Keywords:kbbug kbfix KB253180
©2004 Microsoft Corporation. All rights reserved.