Trigger Equivalents in Access

[SimonFinn]

Hi

I need to execute some VB code when a field updates in Access. The update will come from ADO from an ASP script so i cant catch the update in a form.

I am wondering if it is possible in Access 2000.

Cheers Si.

 

[SimonFinn]

Sorry just to add to this, it is on an insert not an update.

Thanks Si.

 

[JeremyNYC]

Si,

Sorry, not possible. Access doesn't support any triggers. You can, of course, write code to deal with lots of instances, but in some cases you end up SOL on this one.

Would it work to write sql to do the work after the data have been imported? It doesn't give you the same assurance as a trigger, but if you make sure the import is only run as part of code that also fires the sql to do the follow-on work, that should be sufficient for a lot of purposes, if not all.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[willir]

Si

Jeremy is correct about the Access.

Since the update will be done at the code level, only rules defined for the tables and design schema will be enforced. (I.e., primary key, referential integrity.)

(This is one of the reasons why updating via ODBC or other external means can be dangerous.)

So what are you trying to do? Will the ADO updates be done from an external or internal source?

Richard

 

[SimonFinn]

Hi Guys,

I have a VB6 program which searches a Word document (that has been downloaded to the server by the ASP code) for keywords.

I think will have to either run the executable from the ASP code or convert the code to VBA and somehow to a Create.Object ("Access.Application&quot from ASP. I think the latter is a more secure method of doing this.

The ADO update is executed from the local ASP page.

Thanks Si.