Hi,
I have an Access 2000 database. I have a button which creates a text file in a default location called "search.html". This file contains a HTTP Post. I created a form with data from the database. When the user clicks the button, it creates this file and submits it too.
I have enclosed a couple lines of the code (below). I have used some javascript so onload the form is submitted. This can be seen in the code below. This works great with any version of IE except on machines that have WinXP Service Pack 2. When trying to submit with WinXP SP2 I get the folling message appear in the Information Bar.
"To help protect your security, Internet Explorer has restricted this file from showing active content that could access your computer"
Is there anyway I can get around this. Is there another way of doing the whole process. If anyone can give me any information I would much appreciate it. I am submitting a file that is local file on my machine.
Thanks
Jim
strFileContent = strFileContent & "<body bgcolor=#FFFFFF text=#000000 link=#FFFFFF alink=#FFFFFF vlink=#FFFFFF onLoad=" & Chr$(34) & "AnstatOnline.submit()" & Chr$(34) & ">" & vbNewLine
strFileContent = strFileContent & "<FORM NAME=" & Chr$(34) & "AnstatOnline" & Chr$(34) & " METHOD=POST ACTION= & vbNewLine
I have an Access 2000 database. I have a button which creates a text file in a default location called "search.html". This file contains a HTTP Post. I created a form with data from the database. When the user clicks the button, it creates this file and submits it too.
I have enclosed a couple lines of the code (below). I have used some javascript so onload the form is submitted. This can be seen in the code below. This works great with any version of IE except on machines that have WinXP Service Pack 2. When trying to submit with WinXP SP2 I get the folling message appear in the Information Bar.
"To help protect your security, Internet Explorer has restricted this file from showing active content that could access your computer"
Is there anyway I can get around this. Is there another way of doing the whole process. If anyone can give me any information I would much appreciate it. I am submitting a file that is local file on my machine.
Thanks
Jim
strFileContent = strFileContent & "<body bgcolor=#FFFFFF text=#000000 link=#FFFFFF alink=#FFFFFF vlink=#FFFFFF onLoad=" & Chr$(34) & "AnstatOnline.submit()" & Chr$(34) & ">" & vbNewLine
strFileContent = strFileContent & "<FORM NAME=" & Chr$(34) & "AnstatOnline" & Chr$(34) & " METHOD=POST ACTION= & vbNewLine