Problem with multiple accesses on a Microsoft Access DB
Posted on 2002-04-02
Hello! I am using Delphi to access a Microsoft Access Database via ODBC. The situation is this: I want to have many applications to connect to that database. My problem is that I want to all the applications know when a record has been edited, inserted or deleted, because it must refresh some information/calculations when that happens. The easiest way is with triggers, but I don't think they exist in ACCESS. I tried the after delete, after post, ... events but they only trigger in the application that made the changes, so they're no good(or should they be?).
Another aproach would be to have a system to the applications comunicate with each otherm but I guess the database components/events should do the job,right?
Anyone can help? This is kind of urgent.
Thanks all for your time.