BeforeUpdate on linked table

[IgorM]

Hi

I have a pivottable in excel that is connected to a query in Access. The
query joins a table and a linked table. Is it possible to run some macro
before the linked table is updated in order to check some data in source
file for the linked table? In other words I want to run some code that is
triggered when a user clicks to refresh a pivot table in Excel.

Kind regards
IgorM

 

[Douglas J. Steele]

No, Access doesn't support triggers.

The only way to run code before an update is to use a form.

 

[Krzysztof Naworyta]

Douglas J. Steele wrote:

Not exactly. We can use custom function in WHERE conditions to run some
code:

Select ...
From ...
Where
...
AND
MyFunction() = True

Sometimes MyFunction() can run another SQL...
(Let say some deletes/inserts to temporary table(s)...)

Unfortunately custom function cannot be evaluated from excel (IMHO)...

--
KN



| No, Access doesn't support triggers.
|
| The only way to run code before an update is to use a form.
|
|
| || Hi
||
|| I have a pivottable in excel that is connected to a query in Access.
|| The query joins a table and a linked table. Is it possible to run
|| some macro before the linked table is updated in order to check some
|| data in source file for the linked table? In other words I want to
|| run some code that is triggered when a user clicks to refresh a
|| pivot table in Excel.
||
|| Kind regards
|| IgorM