InfoPath Dev

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

 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.