Hello.
I have an Access application that runs fine on 2007 but not 365.
Tables are DSN-Less linked from a SQL 2008 server.
Everything works except for a routine that processes payments.
It works like this:
The access program writes a record to a table (dbo_Payments)
Once the record is written, it sets the value of a bit field (PayNow) to True
There is a SQL trigger that fires when the value in the field is changed
The trigger calls an SP which processes the payment (sends to processing company via HTTP).
The problem is when the SP runs it writes a record to a log table (PaymentLog). Under 365 I get an error in Access stating that PaymentLog couldn't be accessed.
I'm confused because I don't get why Access would even know about what the SP is doing.
What's different in 365 that's allowing it to see what the Trigger/SP are doing?