I have been attempting to use a simple 'look up a record in' data macro in the AfterInsert event of a table. It works absolutely fine locally but not when I move it up to Sharepoint as a Web App (not a link).
I tried other data macros and discovered that NONE of them work on Sharepoint which leads me to suppose that something needs configuring/ adding to the Sharepoint Site. Does anyone know what this is likely to be and how it could be checked, the Site is maintained by a third party and it would be a lot quickier to tell them precisely what needs to be done rather than just ask them to investigate the problem.
The macros do actually appear to start as I put a diagnostic message out to USysApplixationLog before attempting the Lookup and that appears in the log, the problems only arise as soon as I try to read or write to any tables.