trigger in MS Access

[Anon]

is it possible in ms access (maybe with help of VBA) to write a trigger. for eg.

create trigger XYZ
before delete on ABC
for each row
begin
<CONDITIONS>
OR
<DELETE SOEMTHING SOMEWHERE>
end;
if possible can give me some tips..........
thanking you in advance

deepak

[Anon]

With Access? I don't think so...

and, btw:

What about getting a real database ?

Interbase and Firebird e.g. both provide triggers, and Firebird is open-source

yves

[bastien]

access does not support triggers....though you could write a function or sub to do something...but since only the forms provide area to write VBA, you are outta luck here.

Also look at

postgresql which also supports triggers

bastien