Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Access 2010 Linked Tables Data Macro Question
32 views
Skip to first unread message
Mjbjer333
May 10, 2013, 3:40:19 PM5/10/13
to
I have a sendemail data macro which works in a local file (backend database) but will not work in the front end database.
I have tried both named data macro and table trigger event data macros to no avail.
In my research, I have found the following information:
*Link Tables. Data macros are not supported on link tables; however, you can associate logic on a backend ACCDB database for typical front-end/back-end applications.
*And the Data Macro logic works only with local tables, not linked tables (there are ways around this by placing Data Macro logic in the table in it's native database, the logic will fire even when an update is being initiated by a linked database).
Apparently, there is a way around it which I'm not finding. Any help with this would be appreciated.
Thank you!
I have tried both named data macro and table trigger event data macros to no avail.
In my research, I have found the following information:
*Link Tables. Data macros are not supported on link tables; however, you can associate logic on a backend ACCDB database for typical front-end/back-end applications.
*And the Data Macro logic works only with local tables, not linked tables (there are ways around this by placing Data Macro logic in the table in it's native database, the logic will fire even when an update is being initiated by a linked database).
Apparently, there is a way around it which I'm not finding. Any help with this would be appreciated.
Thank you!
0 new messages