Solved

Problem with multiple accesses on a Microsoft Access DB

Posted on 2002-04-02
2
133 Views
Last Modified: 2010-04-04
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.
Best Regards

Goncalo Martins
0
Comment
Question by:reina
2 Comments
 
LVL 10

Accepted Solution

by:
Jacco earned 300 total points
ID: 6923086
To my knowledge only InterBase supports pushing events to connected applications.

Currently I am using a separate communication server to which all database clients also connect. The server is a simple message broadcaster.

The only other solution IMO is using TTimer triggered database poll actions... But that is quit oldfashioned...

Regards Jacco
0
 
LVL 1

Expert Comment

by:pnh73
ID: 9002809
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept Answer from Jacco

Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
Paul (pnh73)
EE Cleanup Volunteer
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now