arqcom
asked on
Access DataBase change notification event
Is there a way to fire an OnChange like event every time an Access file is modified and be able to detect it in a visual basic application?
I'm trying to instantly update a VB spreadsheet application every time an external Access database is modified (new records added). I also need to know the contents of the recordsets added.
why not update the spreadsheet from the Access app directly?
ASKER
I'm programming a VB POS application. When there's a sale the related info is saved in an Access file.
What I'm trying to do is to monitor the sales from another networked computer, an have a real time information update in a running exe spreadsheet like type application.
What I'm trying to do is to monitor the sales from another networked computer, an have a real time information update in a running exe spreadsheet like type application.
there is no way I know of with the event model in Access to globally capture any / all changes (like Jim said). You could modify your app to write to a table (same field/record gets overwritten) everytime an update is made and have you monitoring program query that field on a timer event and requery if the lastUpdate is later than the last time your monitor checked it.
Steve
Steve
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>a visual basic application?
Access supports VBA. Why the separate app?
>VB spreadsheet application
Excel?