Computed Columns in Access

  • Thread starter Thread starter Luis Garcia
  • Start date Start date
L

Luis Garcia

I want to know if it is a kind of "Computed Columns" in
Access as they are in SQL Server. Also, if are
there "Triggers" or something similar.

Beforehand, thank you very much

LUIS
 
I want to know if it is a kind of "Computed Columns" in
Access as they are in SQL Server.
Click to expand...

Not in Tables; but you can put calculated fields in Queries. Unlike
SQL, queries in Access are generally updateable (with some
restrictions) so this isn't as much a limitation as it seems.
Also, if are there "Triggers" or something similar.
Click to expand...

There are table-level triggers in .adp files, or if your .mdb backend
is a SQL/Server or MSDE table - but native Access JET tables do not
have triggers. Typically one would use Forms as the interface to data
in the table, and use form events (BeforeUpdate, BeforeInsert,
OnDeleteConfirm, and so on and so on) to accomplish the same goals.
 
Back
Top