Create Assertion in tables

  • Thread starter Thread starter ttthello
  • Start date Start date
T

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
 
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.
 
Are these Access tables? If so, Access doesn't support triggers. You would
have to be using SQL Server to use triggers.
 
Back
Top