T TanMan Registered User. Local time Today, 03:52 Joined Oct 15, 2010 Messages 16 May 14, 2012 #1 Is there away in access get notification when a table is updated or add to I am using Access 2007 front end and a 2003 backend, the backend is on the server. Thanks Gary Hull
Is there away in access get notification when a table is updated or add to I am using Access 2007 front end and a 2003 backend, the backend is on the server. Thanks Gary Hull
RainLover VIP From a land downunder Local time Today, 18:52 Joined Jan 5, 2009 Messages 5,041 May 14, 2012 #2 Gary I don't think any answer will be pretty. You could write to a separate Table and show the contents of that Table on your Menu (or other form). Use Datasheet view. Or you could automate an Email.
Gary I don't think any answer will be pretty. You could write to a separate Table and show the contents of that Table on your Menu (or other form). Use Datasheet view. Or you could automate an Email.
spikepl Eledittingent Beliped Local time Today, 10:52 Joined Nov 3, 2010 Messages 6,142 May 14, 2012 #3 What is "notification" exactly? If your tables have a CreatedDate and ModifiedDate for each record, then a query would reveal new or changed record. You could show those, or run some code to do something.
What is "notification" exactly? If your tables have a CreatedDate and ModifiedDate for each record, then a query would reveal new or changed record. You could show those, or run some code to do something.
