InfoPath Dev

Hello all, Please forgive my noobishness in this matter. I work for the government and and at a limited access position, implying non-it position. I do not have access to Sharepoint 2010 Server to upload forms on, so that is out of question. My Need: An Access db that collects status information from an Infopath form for each of the employees in my department. My Manager, then opens the DB which runs a AutoExec to kick out a report and print it for her. The Infopath ver is 2010. The form has 8 fields, one of which is a query from the Db mentioned about to get names for a drop down field. Other are basic fields. I have 2 data connections, one to the main database for the Submit part. And also a Receive to obtain the Names. Both the form and the database are in my Managers Network drive, to which, everyone in my department has RW access to. (I know, that is lame) When I open the form through the network location on a PC running Office 2010, it opens and functions accurately, with no errors. It adds the information to the database and closes the form then (per settings on Submit). My Issue: However, when I go and perform the same task on a PC with Office 2007, I keep getting connection Issues to the Database/Query. Again, I do not have admin rights, do not have access to VSTA or the Sharepoint Server to put the Database and Form on there. As the form is not having any issues with 2010, it is something with Office 2007. As mentioned, being a Noob, not sure what other information I can provide. I have scavaged this forum for any help I could find including looking at the Security and Trust Settings, tried all options including unchecking the recommended box. Making several other changes including creating a certificate. Also looked into installing the Form with .msi instruction on this forum, but as I do not have the Infopath SDK I was unable to get any futher. Just an FYI, although I think you might already know them: Error 1: Failed connection to data source. The query cannot be run for the following DataObject: ABC Query Infopath cannot run the specified query Infopath cannot connect to the data source Infopath has encountered an error. The operation failed. Please please please help.

This isn't you - it is InfoPath.

I don't recall the differences, but I do remember comparing the data connection stored between a form that was saved as IP 2007 compatible from IP 2010 and one that was created in IP 2007 - and there was a difference.

Open your form in InfoPath 2007 in design mode and walk through the data connections again - then try the form again from both IP 2007 & IP 2010.

Hilary, I thank you very much for the very prompt response and also helping me solve the issue (Almost, will explain). What I had to do was: 1. My .accdb was in Access 2010 format and had "HASFUNCTION" as yes due to a code for an event for a button. I had to remove the code and change the "HASFUNCTION" to No. Then, I can to create a new Access Database (following the default as 2007) and then import the original db into this one. For convinience, I named it with "...2007" 2. I had an additional Laptop which had Office 2007. So, I opened the Form in Design mode, and then checked the Data Connections. Although, the location and all the settings were appropriate, when I clicked on Modify, I received the error stating that it could not connect to the db. So I changed all the connections to my new "....2007.accdb" Doing both the above solved my issue. The form works correctly and updates the Database. By Almost up top in the first line, what I now have to do is find a way to perform what that button performed without the database having any more issues, which is now an ACCESS Issue. Again, I thank you very much for getting me on the right path to solve my issue. Thanks, Rahul.