When open a TABLE, can VBA do something in respond to this open table event?

[Martin]

In a FORM, it has the "open event", so that I could write some VBA according
to its opening event. (for example, I can write VBA to operate a password
operation)

However, my quetion is, is a TABLE has the "open event", so that I could
write VBA to operate something when this TABLE is been opening.

Thanks!

Martin

 

[Albert D.Kallal]

No, a table does not.

Do you mean when a table is opened in code, or by a user?

You really do not want to let users open tables directly. There is no
verification of input, there is no way to prevent data from being over
written, or edited, or deleted based on given conditions. All in a all VERY
dangerous concept. This bad idea is outlined here with a bunch of other bad
ideas:

http://www.mvps.org/access/tencommandments.htm

 

[Guest]

The short answer is no.

SQL Server has triggers, but Access has nothing similar at the table level.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

In a FORM, it has the "open event", so that I could write some VBA according
to its opening event. (for example, I can write VBA to operate a password
operation)

However, my quetion is, is a TABLE has the "open event", so that I could
write VBA to operate something when this TABLE is been opening.

Thanks!

Martin

 

[tina]

no, tables don't have events. normally, only the developer needs to open
tables, and only during development; use queries and forms to
manipulate/display table data during normal usage.

hth