InfoPath Dev

Hi, I'm using IP 2007 connecting to a MOSS 2007 server. In my form I have a data connection that retrieves information from a MS SQL Server table to populate a drop down box and then send data to a SharePoint List. I converted the DC to UDC and stored it in a DC library in the same site collection as my site. I published my browser form to my site and everything seems to work fine but when I asked a couple of users to test it, the form bombs with a Warning, when clicking on the "Show error details" link, it says "An error occurred accessing a data source". If they click the "Continue" link, the form displays fine but the drop down list is blank. Can someone please shine some light? I've tried setting the security of the form to full trust with the same results. Please help! Thanks in advance, Gus

Did you approve the data connection in the data connection library?

Ha! Good catch! I hadn't approved it, but I did and still erroring out. :(

Do the users have access to the SQL database?

Users have read/write access to the database.

Can you think of anything else I can check? Thanks in advance, Gus

If you have a user with InfoPath Filler, have them try opening in Filler - you may get an error message with more info. You could also check the SharePoint error logs after they try opening in the browser.