Howto Webonize streaming database
I have written some access vba code, that streams data from an external source into some tables, through an API. works great.
It's a lot of data, about 40k records a day.
I apply filters on the fly when the data comes in, and I end up with a couple hundred records a day, which is written into a separate table.
How can I show this table on my form and have it automatically update the table on the form, as soon as new data comes into the table,without having to press an "update" or "refresh" button?
How can I webonize my form with the table?
I want on my website a page showing my form with the table
thank you very much.