S
SOReilly
Hi
I have an oem application which uses an Access 97 database. I am writing
another application which needs to know asap when any new records have been
added / updated. I know that Access does not support triggers so I exported
the required table to MSDE via ODBC and linked it back to the MDB so that I
could use the triggers in SQL to instruct my application when the table has
been updated.
The problem is that while I can see and modify all of the tables in
Access itself, the oem application cannot see them and will not run. The mdb
does use linked tables already to another mdb file in the same directory.
If I poll the database every 2 seconds with my application checking for
updates, I get blocks of 10~approx records every 5 seconds~approx. I need a
faster update for my end user.
Please help!
Stephen
I have an oem application which uses an Access 97 database. I am writing
another application which needs to know asap when any new records have been
added / updated. I know that Access does not support triggers so I exported
the required table to MSDE via ODBC and linked it back to the MDB so that I
could use the triggers in SQL to instruct my application when the table has
been updated.
The problem is that while I can see and modify all of the tables in
Access itself, the oem application cannot see them and will not run. The mdb
does use linked tables already to another mdb file in the same directory.
If I poll the database every 2 seconds with my application checking for
updates, I get blocks of 10~approx records every 5 seconds~approx. I need a
faster update for my end user.
Please help!
Stephen