I want To configure a listerner to listen record updated, deleted and inserted in my access database.

Question

Hi.
I am worried since. I have an idea but i don't know it is possible To realised it. I want To configure a listerner to listen record updated, deleted and inserted in my access database. I dont know how to do it. But i heard it is possible with other database.
Thanks for any idea.

Answer 1

Can you give a example of listener ? I have not heard if this

Answer 2

Thank you. Nice idea.
Although if you have a choice to design the database. I would choose a sql-database.

You can connect to a access database using a sqlconnection and
oledb.

(Connection string :
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.mdb;
Persist Security Info=False;)

In google I have not seen any post about sql dependcy being used with ms access.

I believe it is not possible due to the fact that you have to set
ALTER DATABASE test SET ENABLE_BROKER
which enables the listener to listen to events in the database

You can however do it your self.
If you have all the code accessing the database.
Just add log-function to every event

It also can be done with the access database
I have seen many post about
Data Macros
audit trail microsoft access
They seem to run macros on a after-update event
and write the results to an extra table.

I haven't worked with it. I was just curious to see if it could be done.

Answer 3

a listerner is just like notepad which register all events occurring on your database such as uodate, new record and delete

Answer 4

Sqldependency and the Sqlnotification handler

Answer 5

can you give me the link To the post where toi saw it please.

Answer 6

https://www.techrepublic.com/article/a-simple-solution-for-tracking-changes-to-access-data/
http://allenbrowne.com/AppAudit.html
https://www.youtube.com/watch?v=lfbewGCO8vQ

https://scottgem.wordpress.com/2012/10/18/audit-trail-using-data-macros-2/
https://www.databasejournal.com/features/msaccess/article.php/3905921/Leveraging-Data-Macro-in-Microsoft-Access-2010.htm

Answer 7

Ok thank sneeze