Access and Infopath

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Matt - 27 Sep 2004 20:01 GMT

This was posted by somebody a few days ago, but go no
replies. I am having the exact same issue. Has anyone been
able to resolve it yet? Thanks in advance!....

I created an Access 2003 database, and then created an
Infopath form based on it. When both Infopath form and
Access database are saved on my computer (C: drive), they
work well. I can enter new record and query the database.
But after I published the Infopath form to SHAREPOINT form
library, they didn't work no matter whether I saved the
Access database in my C: drive or in a Server. When I
tried to run a query, I just got the message 'Infopath
cannot run the specified query' and 'InfoPath cannot
connect to the data source. Safety settings on this
computer prohibit accessing a data source on another
domain.' Any help and suggestion with regard to solve the
problem will be highly appreciated. Please reply to
wma6@yahoo.com. Thanks!

Reply to this Message

Jerry Thomas [MSFT] - 28 Sep 2004 03:04 GMT

I haven't had a chance to set this up and test it, but I believe you are
running into permissions issues.
Put the database where you want it and the form where you want it.
Then reconnect the form to the database.
Make sure the form Security level is set to Full Trust.

If this doesn't work, I'll try setting up something to try and repro your
problem.

Signature

Jerry Thomas[MSFT]
<Jerryth@online.microsoft.com>
Microsoft Office InfoPath
---------------------------------------
This posting is provided "As Is" with no warranties, and confers no rights.
Use of any included script sample are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
Please do not send email directly to this alias. This alias is for
newsgroup purposes only.

> This was posted by somebody a few days ago, but go no
> replies. I am having the exact same issue. Has anyone been
[quoted text clipped - 14 lines]
> problem will be highly appreciated. Please reply to
> wma6@yahoo.com. Thanks!

Reply to this Message

Matt - 28 Sep 2004 14:11 GMT

Well I am posting this form to a sharepoint services site
on a server remote from my location. What I need to do is
set the form on this site and then be able to link it to
the database which would be somewhere else where users can
use it at any time from any location. Would this be
accomplished through someone who has local access to the
server running sharepoint to deposit the DB on it and set
the data connection?
Thanks!
Matt

>-----Original Message-----
>I haven't had a chance to set this up and test it, but I believe you are
[quoted text clipped - 25 lines]
>
>.

Reply to this Message

Jerry Thomas [MSFT] - 28 Sep 2004 17:08 GMT

Once the db is set up, you would go through InfoPath to point to the new
location.

Signature

> Well I am posting this form to a sharepoint services site
> on a server remote from my location. What I need to do is
[quoted text clipped - 54 lines]
> >
> >.

Reply to this Message

matt - 28 Sep 2004 19:53 GMT

Yeah, but the bottom line question I am trying to get at,
is how do I point it at a database on the sharepoint
services site? Is it possible even? Basically I need
people outside of the domain where the db resides to be
able to submit/retrieve from it using InfoPath forms
located on the sharepoint site.
Matt

>-----Original Message-----
>Once the db is set up, you would go through InfoPath to point to the new
[quoted text clipped - 60 lines]
>
>.

Reply to this Message

Pranav Wagh[MSFT] - 05 Jun 2005 15:13 GMT

Hi,
It seems the basic issue is this, that you want to use Access DB as SQL
Server, Access DB is optimized to use on a single machine or a small org.
have you tried using SQL Server..?
This will solve your Issue
--------------------
Content-Class: urn:content-classes:message
From: "Matt" <anonymous@discussions.microsoft.com>
Sender: "Matt" <anonymous@discussions.microsoft.com>
Subject: Access and Infopath
Date: Mon, 27 Sep 2004 12:01:33 -0700
Lines: 19
Message-ID: <3c2801c4a4c4$67ed80a0$a401280a@phx.gbl>
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
thread-index: AcSkxGftERgPHeFVRumX3J9GL90uHw==
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
Newsgroups: microsoft.public.infopath
Path: cpmsftngxa06.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.infopath:12570
NNTP-Posting-Host: tk2msftngxa12.phx.gbl 10.40.1.164
X-Tomcat-NG: microsoft.public.infopath

This was posted by somebody a few days ago, but go no
replies. I am having the exact same issue. Has anyone been
able to resolve it yet? Thanks in advance!....

I created an Access 2003 database, and then created an
Infopath form based on it. When both Infopath form and
Access database are saved on my computer (C: drive), they
work well. I can enter new record and query the database.
But after I published the Infopath form to SHAREPOINT form
library, they didn't work no matter whether I saved the
Access database in my C: drive or in a Server. When I
tried to run a query, I just got the message 'Infopath
cannot run the specified query' and 'InfoPath cannot
connect to the data source. Safety settings on this
computer prohibit accessing a data source on another
domain.' Any help and suggestion with regard to solve the
problem will be highly appreciated. Please reply to
wma6@yahoo.com. Thanks!

Reply to this Message