ACC2000: Cannot Administer SQL Server Rules Through Access Client-Server User Interface (232577)
The information in this article applies to:
This article was previously published under Q232577 Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access project (.adp).
SYMPTOMS
You cannot create, view, or administer SQL Server rules through the Microsoft Access Client-Server user interface.
RESOLUTION
In Microsoft SQL Server 7.0 and the Microsoft Data Engine (MSDE), rules are provided as a backward compatibility feature. User interface components to administer rules have therefore not been included in Microsoft Access 2000. Generally, you should use check constraints to perform the same functions that rules do.
To create, bind, administer, and drop rules in a user database, use the Transact-SQL statements and stored procedures listed below in one of the SQL Server client tools such as SQL Server Query Analyzer or OSQL: - sp_help
- CREATE RULE
- sp_bindrule
REFERENCES
For more information about rules, SQL Server Query Analyzer, or OSQL, refer to SQL Server 7.0 Books Online available for download from the following address:
| Modification Type: | Minor | Last Reviewed: | 8/10/2004 |
|---|
| Keywords: | kbdownload KbClientServer kbprb KB232577 |
|---|
|