Article ID: 247488 - View products that this article applies to.
This article was previously published under Q247488
This article has been archived. It is offered "as is" and will no longer be updated.
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.mdb).
The user-defined properties that you set for all columns in a query may be deleted. If you are using Data Access Objects (DAO) code, the query does not return a value for the properties or uses the properties from the table that the query is based on.
You may also receive one or more of the following error messages when you run the query:
Property can be set only when the Field is part of a Recordset object's Fields collection.
Operation is not supported for this type of object.
Property not found.
This problem can occur when you have Name AutoCorrect enabled, and you do one of the following:
IMPORTANT: If you have Access 2000 running on Microsoft Windows 2000, Microsoft Office 2000 Service Release 1 (SR-1) will not correct this problem.
To resolve this problem on Windows 2000, obtain Windows 2000 Service Pack 1 (Win 2000 SP1). For information on downloading SP1 or obtaining the Windows 2000 SP1 CD, please visit the following Microsoft Web site:
http://www.microsoft.com/windows2000/To resolve this problem on non-Windows 2000-based computers, obtain Microsoft Office 2000 Service Release 1 (SR-1). 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:
245025Even though Office 2000 SR-1 corrects the problem of deleting user-defined properties, the DAO code may not return the expected information. For example, if the table that your field comes from has text in the Description property, the code returns the table's description instead of the query's description. To avoid this behavior, make the Name AutoCorrect command unavailable. To do so, follow these steps:
(http://support.microsoft.com/kb/245025/EN-US/ )OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in Windows 2000 Service Pack 1.
Steps to Reproduce Behavior
For additional information about a similar issue involving ActiveX Data Objects affecting queries in an Access database, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/256101/EN-US/ )ACC2000: Properties Are Missing from Queries After You Access TableDef Object with ADOX Catalog Object
Contact us for more help
Connect with Answer Desk for expert help.