ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   ADO Security Warning (https://www.excelbanter.com/excel-programming/289377-ado-security-warning.html)

Martin Eckart

ADO Security Warning
 
Hi guys,

I am not sure if it is the correct NG, but I will try:

I created a Connection Macro in Excel which gets Data from an SQL Server.
Therefore I had to add the Reference MSActiveX Data Objects Library (I took
2.7). After having done this I always get the following Message while trying
to get data from another Device:

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.

Am I wrong in assuming this message is related to the Reference I added? Is
it just IE Security Setting?

Any help appreciated,

Thanks,
Martin



Rob van Gelder[_4_]

ADO Security Warning
 
Martin,

Sounds like an IE security warning.
Have you tried searching that sentence in Microsoft's TechNet?

Rob


"Martin Eckart" wrote in message
...
Hi guys,

I am not sure if it is the correct NG, but I will try:

I created a Connection Macro in Excel which gets Data from an SQL Server.
Therefore I had to add the Reference MSActiveX Data Objects Library (I

took
2.7). After having done this I always get the following Message while

trying
to get data from another Device:

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.

Am I wrong in assuming this message is related to the Reference I added?

Is
it just IE Security Setting?

Any help appreciated,

Thanks,
Martin






All times are GMT +1. The time now is 05:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com