Create Assertion in tables

[ttthello]

Hi,

I am trying to write "create assertion" for tables but microsoft acces
sql does not recognise this syntax.

How can I perform this function ? What are triggers anyway ?

Regard

 

[Jeff Boyce]

MS Access does not have triggers for its tables. Assertions, as I
understand them, only work in code modules, at least for Access.

Access DOES offer a very rich event environment through its forms -- rather
than work directly in the tables, consider working via forms.

If you are considering use of SQL Server for a back-end, triggers are
available there.

 

[Wayne Morgan]

Are these Access tables? If so, Access doesn't support triggers. You would
have to be using SQL Server to use triggers.