ACC2000: Can't Administer SQL Server Rules Through Access Client-Server User Interface

ID: Q232577

The information in this article applies to:
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:


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:

http://support.microsoft.com/download/support/mslfiles/sqlbol.exe

Additional query words: prb 


Keywords          : kbdta AccessCS 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: June 10, 1999