yermaw
asked on
Automatic reading of database values
I have a requirement to have multiple access to a database over a network. The requirement also includes my VB5/6 application to constantly read the database for changes made by other systems on the network.
Is there anyway to be notified of changes to a database without having to constantly check the database contents using a timer?
If so, is there any code snippets available as I don't have a clue !
Is there anyway to be notified of changes to a database without having to constantly check the database contents using a timer?
If so, is there any code snippets available as I don't have a clue !
ASKER
Edited text of question
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
So u have to see if anther application has accessed your access database ?
do u have to see or show if thath has happened , which record it was ?
Long shot but could u not use the windows api to tell you when the database was last modified. Keep track of thath value in a ini file and compare the dates and times .
just an idea
Craig