Form Template not connecting to Access 2007 DB - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Form Template not connecting to Access 2007 DB

Last post 12-09-2008 09:39 PM by madhuri. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 12-09-2008 09:54 AM

    Form Template not connecting to Access 2007 DB

    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.

  • 12-09-2008 09:38 PM In reply to

    • Anuma
    • Top 25 Contributor
      Female
    • Joined on 07-20-2005
    • India
    • Posts 525

    Re: Form Template not connecting to Access 2007 DB

    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.

    Anuma Chinthapalli /
    http://www.GGKTech.com
  • 12-09-2008 09:39 PM In reply to

    Re: Form Template not connecting to Access 2007 DB

    Hi

    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 ?

    Madhuri
    http://www.ggktech.com
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.