Monitor Database and send UDP command

[elfranzen]

OK this is what I am trying to do. I have some digital signs that play different videos. these controllers can listen for UDP command Via Ethernet. what I would like to do is use access to start at a certain time. (I know how to do this) and connect to a SQL when the database is updated with new data. It triggers a VB code that sends a UDP command that triggers the signs to show a video.

so two parts to this question and any help to either would be awesome.

1. how to trigger VB when a database has been written to?
2. the VB code to send the UDP command

Thanks.

 

[mdlueck]

1. how to trigger VB when a database has been written to?

What sort of database do you need to monitor?

If SQL Server, with enough/correct perms granted to the ID you use to access SQL Server, you should be able to monitor the last update timestamp of the index on the table to see when a change has been made to the table.

I do not seem to be able to lay my hands on the sample code I had to accomplish this. The ID I have to access SQL Server did not have enough perms to query against the correct sys table, so I am not using that technique in this application. Perhaps I have it stashed away elsewhere... I will look around later.

 

[elfranzen]

it is a SQL database. I am not able to work directly in the SQL server due to some regulations and other stuff. that is why I am using Access. they seem to be fine with this type of connection as I am very careful to only read data from the tables and I always test my stuff to a backup database first just to make sure.