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

ID: Q232577

The information in this article applies to:

Microsoft Access 2000

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:

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

Additional query words: prb

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