Accessing the datatables behind a Access web app: access denied RRS feed

  • 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?

    Monday, May 16, 2016 7:39 AM


All replies

  • SOlved it - the ODBC connection has to be machine type.
    Monday, May 16, 2016 8:12 AM
  • 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,


    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.

    Tuesday, May 17, 2016 1:21 AM