I have developed a from in InfoPath 2007 that has some dropdowns that get information from access tables. The form works well for me, but there are security issues when others try to open it. They can generally get past them (looking for a smart card), but they cannot get ALL the information that is coming from Access. They get error messages on 4 of the 7 tables. This happens both in InfoPath on a shared server (the access tables are in the same place) or if published to Sharepoint. How can I fix this?