ADO Security Warning

[jody frazier]

I have a form that connects to an Access DB to pull info into the InfoPath
form. Everything works great except I get an error when first opening the
form. If I chose OK all is well but I would like to bypass the error if at
all possible. Here is the error message: "ADO Security Warning:This website
is using your identity to access a data source. If you trust this website,
click OK to continue, otherwise click Cancel."

Anyone know how to bypass this error?

 

[S.Y.M. Wong-A-Ton]

Try this thread:
http://groups.google.com/group/micr...Level+Security+&rnum=1&hl=en#84df8847262c7fb2

 

[jody frazier]

Thanks for the link! After reading the information in the link, I tried to
add my C drive to the Trusted Sites. However when I try to type in "c:\" I
get an error message saying I've used an invalid wildcard sequence. I
uncheck the box that requires sever verification (https for all sites in
this zone. Yet I still get the error message. Anyone know how to add your C
drive to the Trusted Sites List?

 

[S.Y.M. Wong-A-Ton]

Try setting "Access data sources across domains" to "Enable" first before you
try the solution to add the C:\ drive to the Trusted Sites (not sure if that
was an accurate solution or not, since I've never tried it). You can find
this setting when you open Internet Explorer, go to "Tools > Internet
Options", click on the "Security" tab, select Internet zone, and click on the
"Custom Level" button to open the "Security Settings" dialog box.

Adam said that you needed to add the UNC of your form to your list of
trusted sites. The UNC would look something like \\COMPUTERNAME\C$\MyForm.xsn
if your form is located at C:\MyForm.xsn. To get your computername, open
Windows Explorer, right-click on "My Computer", select "Properties" from the
context menu that appears, and click on "Computer name" tab.

Please post back what solved your problem; this way others will know too.
Thanks.

 

[jody frazier]

Thanks for all the help S.Y.M. but so far nothing I have done has prevented
the ADO Security Warning from popping up each time I open the form.

Anymore ideas?

 

[S.Y.M. Wong-A-Ton]

The only thing left is to give your form Full Trust, Jody. Take a look at
this article if you do not know how to do that:
http://msdn2.microsoft.com/en-us/library/aa662309(office.11).aspx

Also take a look at the InfoPath help file:
http://office.microsoft.com/en-us/infopath/HP011053061033.aspx?pid=CH011096881033

If you're using the form standalone (by itself), you can install it on your
machine. If you're using it within SharePoint, you'll need to digitally sign
it (see
http://office.microsoft.com/en-us/infopath/HP011053381033.aspx?pid=CH011097171033) when you give it full trust.