ADO Security Warning - using identity to access a data source

[jakewolfe]

I'm getting an ADO security warning when I submit data from an .xsn to an
access database on a LAN Server. I've published the form, changed the
security settings to allow access to a data source across domains, and I
still get the error message (well, actually get it 4 times, once for each
data source).

Any suggestions?

 

[Franck Dauché]

Hi,
Data still go through or not?
Regards,

Franck Dauché

 

[mikelee]

I'm getting the same secuity warning on all machines except for the one that
created and published the form. My form retrieves data from Access, the form
opens with the retrieved data once i click OK to close the warning dialog
box. Is there anyway to get rid of this warning message?

 

[jakewolfe]

Yeah, goes through one warning for each data connection, then allows the form
to open. Same problem as mikelee, I think, except I get the message on all
machines, including the one I put the form on.

 

[jakewolfe]

Forgot to mention: The warning tells me that my identity is being used to
access data on another domain. don't know if that helps or not

 

[Franck Dauché]

Hi,

Did you try these steps suggested by Scott Heim from MS in this forum:

InfoPath makes use of Internet Explorer's security - as such, if you want
to eliminate this prompt complete the following steps:

- Launch Internet Explorer
- From the Tools menu choose Internet Options
- Select the Security tab
- Assuming you are on a "Local Intranet" select this option and then click
the Custom Level button
- Scroll to the section: Miscellaneous and enable the option: "Access data
sources across domains"

Hope that it helps.

Regards,

Franck Dauché