Developing Client side application for real time database

R

rohitk18

Hi
I want to develop client side application using MS Access 2002 . This
application will communicate with the rael time database server developed for
chemical plant DCS. This server updates the tag values every minute.
The proposed client application will get information about few tags from the
DCS databse server, perform certain calculations, and return sub set of
calculated tags to the server databse.Client application may not run in
synchronous manner but need to perform the required calculations in scheduled
manner.
I would appreciate if you could provide some hints for the above case.
Thanks
 
L

Larry Linson

How much Access experience do you have?

At least since 1994, when Access v. 2.0 was released, Access has been a
superb tool for creating client applications for any ODBC-compliant server
database, or any server database that has an ADO data provider.

You can use the Form's timer feature to "wake it up" to sample new data on a
periodic basis as you describe.

What you didn't say was what database product the chemical plant DCS is
implemented in, or whether it was ODBC-compliant, or had an available ADO
data provider. Those would be the deciding issues as to whether it could be
used as a server with an application developed in Access 2002 as a front
end.

Larry Linson
Microsoft Access MVP
 
Top