Accessing the datatables behind a Access web app: access denied

Question

I have an access 2013  web app running against Office365.  It works fine.

However I wish to read/write access the data tables inorder to import expertnal data into the tables easily.  So I have set up access as shown below and accessed the connections details using the "View Read-Write Connection Information".  However depite several attempts I get "Client with my IP address is not allowed to access the server".  What have I done wrong?

Answer 1

SOlved it - the ODBC connection has to be machine type.

Answer 2

Hi Martin,

Thanks for sharing.

I am glad your issue has been resolved, and I suggest you mark your reply as answer to close this thread, and then others who run into the same issue would find the solution easily.

Best Regards,

Edward

---

We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
Click HERE to participate the survey.