InfoPath Dev

Hello All, Feeling good to join this forum. I have a question on Infopath 2010. I have created a MS Access db and linked the db to a Infopath Form. This form is for a training feedback which will be shared through email with a submit button. I kept the form & the MSDB in the same shared location where the recipient of the form has access too. However i am neither able to send or open the form. It gives an error saying Access Denied. Data Connection source cannot be reached. Can you please let me know what should i do now. As an alternative i am sending the form as email and instead of db i am manually storing the data using simple copy paste option which is a mammoth job. Is there any way to have data connection where data willm be saved in excel or access format when they fill the form and submit through email. Need urgent help. Thanks! Sudip

1. Check you haven't relocated the database/form since originally setting up the main (or otherwise) data connection. When you publish a form, it still expects to find the Access database where you originally connected to it. You can 'repoint' the form's main datasource via the main dataconnection configuration. 2. You can submit via email until the right part of the workflow where the database submit is needed - only make the submit to db button available then. Though if retrieving records back into the form are part of your requirement you'll still need the db somewhere that all users who read/submit to it can access it via the form. 3. The form in an email is already just 'the data' - but if you want the submitted data to be in excel format or otherwise, you'll probably need to have some code to convert the form xml to something else and then manually create email/attach and send. i.e. not really a built in InfoPath function.