Click to See Complete Forum and Search --> : [RESOLVED] Access 2K & Web


sebass54
February 15th, 2001, 03:45 PM
This is my first shot at developing a DB from the ground up with ERDs, everything, from scratch...so bear with me.

I created my tables, queries, etc. Now in Access I made a Data Access Page that will display one of my queries.

So I publish it to my 2000 box running IIS 5 and whenever I try to pull up one of the pages on IE, I get an error that I am not able to access data sources from another domain.

I looked it up in the knowledge base and all I could find was to add myself as a trusted site or turn down the security settings on IE to allow data access across domains.

Any ideas? Thanks!

------------------
"then it comes to be that the soothing light at the end of your tunnel, is just a freight train coming your way..."

nutt69
February 15th, 2001, 11:44 PM
Go to your tools menu then internet options and then go to the security tab and click on custom level. Scroll down list until you see "miscellaneous", then below that it will say "access data sources across domains", you will want to "enable" this. It has been awhile since i have done this so let me know if it works.
Nick

sebass54
February 16th, 2001, 07:33 AM
<font face="Verdana, Arial" size="2">Originally posted by nutt69:
Go to your tools menu then internet options and then go to the security tab and click on custom level. Scroll down list until you see "miscellaneous", then below that it will say "access data sources across domains", you will want to "enable" this. It has been awhile since i have done this so let me know if it works.
Nick</font>

I looked it up in the knowledge base and all I could find was to add myself as a trusted site or turn down the security settings on IE to allow data access across domains.

I've done that and it works, I just want to know if it is something I have setup wrong with IIS or ODBC?



------------------
"then it comes to be that the soothing light at the end of your tunnel, is just a freight train coming your way..."

nutt69
February 16th, 2001, 09:42 AM
<font face="Verdana, Arial" size="2">Originally posted by sebass54:
I looked it up in the knowledge base and all I could find was to add myself as a trusted site or turn down the security settings on IE to allow data access across domains.
</font>

Sorry about that, I guess I should learn to read the posts better. I had a Frontpage
class and we had this problem, the only thing that we could do to stop that from happening was to do what you have already done. So as far as I know, that is the only way to do it, but I could be wrong.
Nick