I created a form in InfoPath 2007 and linked it to an Access db (also 2007) table. Last night the data connection worked fine. This morning I went into the table and changed the data in a field - in fact, all I did was add 1 letter to a name in a cell, so I could see if that change would show in the data in my form. After I did that, I opened the form and tried to do the EXACT same function I did last night, and today I get an error message "InfoPath cannot connect to a data source". When I click on Details, there's this:
The query cannot be run for the following DataObject: gain loss data connection
InfoPath cannot run the specified query.
[0x80040E10][Microsoft OLE DB Provider for ODBC Drivers] [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Is the problem because because I changed the Access table data (NOT the structure, just the data in a field), or something else? If the data change, my problem becomes a whole lot bigger, because the data will change daily.
I've scoured the Internet today and seen comments about Full Trust access needed. However the way they say to grant that Access I don't see in the menus in InfoPath 2007. I'm stumped. Anyone got any ideas?
Thanks!