Computed Columns in Access

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
 
J

John Vinson

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

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.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top