Microsoft Access

Re: InfoPath form having issues connecting to Access database

Patrick Halstead — Sun, 22 May 2016 23:23:15 GMT

Hi Spotswood,

We don't recommend using Access for InfoPath data collection because there is no way to lock data nor handle network license issues...

We recommend you use SQL Express (free) and our Database Accelerator Web Service (DBXL, also free trial).

We can help you set this up, but there is a fundamental difference between Access-backed tightly coupled forms, and SQL-backed, loosely coupled DBXL forms.

You may need to recreate your form, but it should not take a lot of time.

Installing DBXL and sending out a link to people to fill out should not take much time either.

Email me if you have any issues.

Best,

InfoPath form having issues connecting to Access database

Spotswood — Wed, 18 May 2016 20:04:40 GMT

I am coming on here because I was assigned a project to help collect work data (#'s of each task completed) and I have set up the database and form in the shared network drive. The form submits perfectly for me, but when anyone else (even those with NO restrictions in network drive) tries to submit the form, it tells them the database cannot be found. I have gone on their computer and looked to make sure that the path is correct as well as to make sure the bindings were still working on the form. I have even gone and added the network drive to the intranet section under IE security.

My questions is what do I check next?