How to populate a drop down list from a Access database on a form that is emailed?

[kammsba]

I have  a survey form that is emailed to hundreds of members and the first field is a drop down list with members names that I populate from an Access Database.  The form is emailed to members but it is requiring the client to have access to the server to populate the drop-down list?  I need to populate the list at the time I distribute the form and the list is static at that point.  How?

[dcidev]

You might have to generate an xml file from your Access Database with a list of member names. After that you can create a new data connection using Sample XML Data then map the drop down to the list.

Then every time you distribute a new form, import the latest xml generated from your Access database to update the drop-down.

Hope that helps.

Kyle

[dggambal]

Please provide more specific steps as I've never tried anything like this before.

Thank you