Our company has recently began piloting Office 365 with a Microsoft recommended security setting to disallow full-trust forms. Most of our forms have SQL database connections to populate drop down boxes. We changed our forms for Office 2013 compatibility to full-trust, which did not affect our user base of predominantly Offfice 2007. We are getting a lot of feedback however from the pilot group that they are unable to open the forms because of the security restriction... has anyone else gone through this, and had any success with resolving? When I try to change the security on one form to Domain, Restricted or Auto, the form fails to open in Office 2013 because it is unable to access data from SQL. Since I am not a member of the pilot group for Office 365, I cannot test the forms on that platform.
Any suggestions/recommendations/feedback would be welcome.