I created an InfoPath 2007 form that connects to a MS Access 2003 .mdb file that allows a user to select a record group from within the form using a drop-down box and then update all records in that group. The form uses a drop-down to query the Access .mdb file and then presents all records. Both the Infopath form and Access databases are saved on a network drive. The form works fine in PREVIEW mode. However, when I access the form directly or publish the form using a different name, and then select the record from the drop-down, it comes back with error "Some rules were not applied".
details:
The query method on the Document object failed.
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Access is denied.
Access is denied.
I am not using Sharepoint and not attempting to access via a web browser.
Does anyone know how to resolve this? We are trying to use this form to update a simple access database. Both on the same network drive/folder.