Hi,
I current have a request from users that they want to see when and who was the last updated on a record(s) on a table (I used Access form to display data for users). The database is in SQL Server 2005 and I am using Access the front end.
I have no clue what should I do to show who/when changed the data in Access form. I can run a trigger in SQL and I see who and when changed the data, but I can't show it in Access form because we are talking about two application here.
Can someone help me to figure out what should I do or give me a guideline where should I start?
Thank You.
I current have a request from users that they want to see when and who was the last updated on a record(s) on a table (I used Access form to display data for users). The database is in SQL Server 2005 and I am using Access the front end.
I have no clue what should I do to show who/when changed the data in Access form. I can run a trigger in SQL and I see who and when changed the data, but I can't show it in Access form because we are talking about two application here.
Can someone help me to figure out what should I do or give me a guideline where should I start?
Thank You.