Hi,
I am new to database development so my question may seem
trivial. Here is the problem: I have an MS Access database
file which can be updated by more than one client
application (more specifically, one of them is MS Access,
another is Web browser running an ASP document and the
third is some COM object written in C++). If one client
application updates the database, all other client
applications need to refresh their status immediately
(say, update GUI). Local database experts assured me that
there is no simple or built-in solution for
notifying database clients of the change in database.
I've seen at least one posting here from a person who had
similar problem (he solved the problem by sending UDP
messages). This solution, however, is quite low-level and
only works for code you have control over. I am sure other
developers faced the very same problem in the past. The
question is, what is the common way to create a communication
channel between database clients? The best I could come up with
is creating a singleton COM Automation object, embed it in every
client application and use it as a synchronization entity.
Thanks,
Vitali