G
greg appelt
I also had this problem on my new Win7 Pro box with SQL 2008 and InfoPath 2007. While in design mode of the form, go into the menu selection Tools/Form Options, selecting the Security and Trust category, deselecting the Automatically determine security level, change the radial button to Full Trust and click OK.
The form now can make an ADO connection to the database defined in the data sources. No more Access Denied when attempting to Open, Submit, or Query data!!
todd golterman wrote:
Access is denied
03-Mar-09
I am having a similar issue as one you posted several months back (I hope your project worked out). I set up an access database on a laptop at home and am trying to get infopath to access it. I can see the fields, but am getting "Access is Denied".
Did you learn how to fix this?
Previous Posts In This Thread:
Access is denied, but Windows User has rights to DB
Hi
I have built and InfoPath 2007 form and supporting (.NET 2.0) web service,
which both work fine on my development machine. However, I am integration
testing the solution on a Windows 2003 Virtual PC Image
When I host the form on the VPC image, I cannot get InfoPath to connect to
*anything* (not even directly to a SQL Server table). I keep getting "The
query cannot be run for the following DataObject: Main connection. InfoPath
cannot run the specified query. InfoPath cannot connect to the data source.
Access is denied. Access is denied.
I am running as the Admininstrator of the machine, I have DBO rights to the
database, and I can connect to the database using my web service and/or
Excel. In fact, InfoPath is able to connect to the database for the purpose
of generating the form schema (and the TEST SQL button works), but it just
can't get any data
This is holding up my entire project (due to be installed at 8.00am THIS
Sunday!)
Hope someone is out there
Best Regards
Chri
--
Chris Boothroy
Presiden
Avatar CTS LLC
HelloWhat is the security level you are using for your Form?
Hell
What is the security level you are using for your Form
-
Kalyan G Reddy - INFOPATH MVP 200
http://www.ggktech.co
:
It was set to automatically detect the security level, but I played around
It was set to automatically detect the security level, but I played around
with that late last night and managed to get the form to work by changing it
to Full Trust
Thanks very much for your help
Chri
--
Chris Boothroy
Presiden
Avatar CTS LL
:
Access is denied
I am having a similar issue as one you posted several months back (I hope your project worked out). I set up an access database on a laptop at home and am trying to get infopath to access it. I can see the fields, but am getting "Access is Denied".
Did you learn how to fix this?
EggHeadCafe - Software Developer Portal of Choice
SharePoint Application Page with Custom Controls
http://www.eggheadcafe.com/tutorial...7-cf150d7f0c5f/sharepoint-application-pa.aspx
The form now can make an ADO connection to the database defined in the data sources. No more Access Denied when attempting to Open, Submit, or Query data!!
todd golterman wrote:
Access is denied
03-Mar-09
I am having a similar issue as one you posted several months back (I hope your project worked out). I set up an access database on a laptop at home and am trying to get infopath to access it. I can see the fields, but am getting "Access is Denied".
Did you learn how to fix this?
Previous Posts In This Thread:
Access is denied, but Windows User has rights to DB
Hi
I have built and InfoPath 2007 form and supporting (.NET 2.0) web service,
which both work fine on my development machine. However, I am integration
testing the solution on a Windows 2003 Virtual PC Image
When I host the form on the VPC image, I cannot get InfoPath to connect to
*anything* (not even directly to a SQL Server table). I keep getting "The
query cannot be run for the following DataObject: Main connection. InfoPath
cannot run the specified query. InfoPath cannot connect to the data source.
Access is denied. Access is denied.
I am running as the Admininstrator of the machine, I have DBO rights to the
database, and I can connect to the database using my web service and/or
Excel. In fact, InfoPath is able to connect to the database for the purpose
of generating the form schema (and the TEST SQL button works), but it just
can't get any data
This is holding up my entire project (due to be installed at 8.00am THIS
Sunday!)
Hope someone is out there
Best Regards
Chri
--
Chris Boothroy
Presiden
Avatar CTS LLC
HelloWhat is the security level you are using for your Form?
Hell
What is the security level you are using for your Form
-
Kalyan G Reddy - INFOPATH MVP 200
http://www.ggktech.co
:
It was set to automatically detect the security level, but I played around
It was set to automatically detect the security level, but I played around
with that late last night and managed to get the form to work by changing it
to Full Trust
Thanks very much for your help
Chri
--
Chris Boothroy
Presiden
Avatar CTS LL
:
Access is denied
I am having a similar issue as one you posted several months back (I hope your project worked out). I set up an access database on a laptop at home and am trying to get infopath to access it. I can see the fields, but am getting "Access is Denied".
Did you learn how to fix this?
EggHeadCafe - Software Developer Portal of Choice
SharePoint Application Page with Custom Controls
http://www.eggheadcafe.com/tutorial...7-cf150d7f0c5f/sharepoint-application-pa.aspx