Article ID: 117168
Article Last Modified on 1/19/2007
APPLIES TO
- Microsoft Access 1.0 Standard Edition
- Microsoft Access 1.1 Standard Edition
- Microsoft Access 2.0 Standard Edition
- Microsoft Access 95 Standard Edition
- Microsoft Access 97 Standard Edition
This article was previously published under Q117168
SYMPTOMS
Advanced: Requires expert coding, interoperability, and multiuser skills.
You can use data access objects (DAO) in Microsoft Access versions 2.0, 7.0, and 97 to change the ownership of database objects (such as tables, forms, and reports) in unprotected Microsoft Access version 1.x databases, even though you cannot view or change the ownership of these objects using Microsoft Access version 1.x.
CAUSE
Although there is no command to change object ownership in Microsoft Access 1.x, the underlying Microsoft Jet database engine does support changing ownership. The method of changing object ownership in Microsoft Access 2.0, 7.0, and 97 works on both version 1.x and version 2.0 databases.
RESOLUTION
To keep ownership of objects in your version 1.x database from being changed, protect the database with the Microsoft Access version 1.x Security Wizard.
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 2.0, 7.0, and 97.
REFERENCES
For more information about database ownership, search the Help Index for "Owner," or ask the Microsoft Access 97 Office Assistant.
Keywords: kbbug kbusage KB117168
