Microsoft KB Archive/253180

= ACC2000: Table Created by User in Db_owner Role Makes User the Owner =

Article ID: 253180

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.
 * 1) On the File menu, click Connection.
 * 2) 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.

Additional query words: pra

Keywords: kbbug kbfix KB253180

-

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

© Microsoft Corporation. All rights reserved.