InfoPath Dev

Secondary data connection that receives from Access.  After making that DC, drag the repeating group of that DC to your canvas and let it create a repeating table.  That will always show the current data from the source.  If you write to the Access DB from within the form, then just have your button requery the receive DC, and it ...

It's best to use the User Profile Service and not the UIL, because downloading the entire UIL into your form could bring it to its knees if you have thousands of users.  Even hundreds is slow compared to the UserProfileService, and the UIL is not populated with every user automatically.

The behavior you're seeing here is the same reason why we can't promote a text field straight into a People field - different data types.  With SPD, I've always been able to push a string into the People field as long as it was the right string, which was an email address. If you end up having to try for email address, then ...

the best thing to do is to DEFINE the filename yourself before the file gets submitted by putting it in a field and then configure your submit data connection to utilize that field.  It's better that way so that your users aren't typing in filenames and so that you always have unique filenames.  I have a blog showing how to do ...

Browser forms are currently only possible within SharePoint (MOSS Enterprise actually), otherwise everyone will have to have the same version of InfoPath as the form template itself. Did you see my answer on MSDN/TechNet?  You didn't reply there, nor acknowledge it as an answer.

I haven't encountered that before, sorry.

First, promote the AccountId field to the form library as itself, but hide that column from your view.  Then, upon submission, the workflow should kick off and should use Set Field in Current Item. All you do is set your people picker field to the value of AccountId.  For me, I've always had to use the email address for this to work, ...

Yes, you're getting there - it's all permissions/security from here.  I got all the rest of that from blogs online, but I didn't keep track of where they were. You'll just need to search for each concept individually. Converting the DCs to UDC is simple.  Just click Tools > Data Connections > and do it ...

Set the query field value to null as the first action in your New Record button?

Yeah, that's how it works, but it's a very complicated process with a browser form - not as bad with a rich client form. It still is very powerful without using a DB on the back-end.  What is your requirement that necessitates SQL?