Microsoft KB Archive/232577

= ACC2000: Cannot Administer SQL Server Rules Through Access Client-Server User Interface =

Article ID: 232577

Article Last Modified on 8/10/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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

