Re: Infopath form connects to Access Database with Office 2010 but not office 2007

Hilary Stoupa — Tue, 16 Jul 2013 01:26:59 GMT

Pop the form open in design mode on an InfoPath 2007 machine and walk through the database connection again. I think I remember seeing that InfoPath 2010, even though the form was saved as IP 2007 compat, was doing something hinky with the data connections.

Infopath form connects to Access Database with Office 2010 but not office 2007

douala — Wed, 03 Jul 2013 16:58:53 GMT

This has been a thorn on my side for a week!!!!

I have designed an Infopath form that retrieves data from an Access Database via a button.

The Access database is located in a shared drive where all users have access.

I have even changed the Access database from .accdb to .mdb

The form retrieves data perfectly for users who have Office 2010. Infopath gives an errors "Infopath cannot run specified query" with users who have Office 2007 as soon as the button is clicked.

I have been seraching and searching online and no solution.

My security is set to "Full Trust". My form is an "Infopath Filler 2007", I do not know what to do next?

Thanks

Microsoft Access

Re: Infopath form connects to Access Database with Office 2010 but not office 2007

Infopath form connects to Access Database with Office 2010 but not office 2007