Data Connections

Re: Form Template not connecting to Access 2007 DB

madhuri — Wed, 10 Dec 2008 05:39:38 GMT

Check whether the users has permission to acess the DB.

And I have one question for, is ‘Automatically retrieve data when form is opened’ option is checked for the Submit DataConnection ?

Re: Form Template not connecting to Access 2007 DB

Anuma — Wed, 10 Dec 2008 05:38:33 GMT

Hi,

Is all your users have write permissions for Access db?

Follow the steps given below if it is the domain access error:

1. Go to IE ToolsàInternet OptionsàSecurity tab

2. Select Local Intranet.

3. Click ‘Custom Level’ button.

4. Under ‘Miscellaneous’.

5. Under ‘Access data sources across domains’.

6. Check ‘Enable’ radio button and click ok.

Hope this helps you.

Form Template not connecting to Access 2007 DB

maybewecan — Tue, 09 Dec 2008 17:54:06 GMT

Hi....I have been reading through post here to try and find a solution to my problem I am having. First let me explain what I am trying to do. I have created a basic form connecting to a data source so I can submit data to it. It is a MS Access DB. When I click the "Submit New Request" button I want it to populate the DB and send and email. I got this work on my laptop perfectly, but when I publish it to sharepoint only I can make it work right. My colleagues can not submit the data. they get an error that says "The form template can not cannect to the data source". Now before you ask me where I put the DB, I tried it on two locations...One I shared it out on my laptop for testing and the second I put it on the SP server itself. Surely, I am doing somthing wrong. What is the best practice here for waht I am trying to do? How can I make this work right for everyone?

Thanks for the help in advance.