With MS Access 2002, we created a Data Access Page that we have been using for several years with Windows Internet Explorer 5 or 6. The page includes a navigation control so the user can click from one record to the next.
Now we've just upgraded to IE 7, and this nav control no longer works, but shows up as a box with a red X in it. It appears to be a Java or Active X control that is no longer working.
When accessing the page in IE 7, a warning pops up:
"Microsfot Data Access Components: This Website uses a data provider that may be unsafe. If you trust the website, click OK otherwise click Cancel."
Click OK, and you get a second warning:
"Microsoft Office Web Components: This website is using your identity to access a data source. If you trust this website, click OK to continue, otherwise click Cancel." [Note: The page determines the recordset based on the user's login ID.]
Click OK, and the page finishes loading. The user sees his first record, but the nav control is only a red X, and he cannot get to any other records in the recordset.
On the HTML of the Data Access Page. the code for the nav control is as follows:
--------------------------
----------
----------
----------
----------
----------
----------
----------
-------
<DIV class="MSOShowDesignGrid Mso2dSection" id=NavigationToDoListWilli
am
style="VISIBILITY: inherit; OVERFLOW: hidden; WIDTH: 672px; POSITION: relative; HEIGHT: 43px; BACKGROUND-COLOR: transparent">
<OBJECT id=ToDoListBobNavigation
style="LEFT: 236px; WIDTH: 340px; POSITION: absolute; TOP: 4px; HEIGHT: 25px"
codeBase=\\msowc.cab classid=CLSID:0002E554-000
0-0000-C00
0-00000000
0046><PARA
M NAME="_State" VALUE=""><PARAM NAME="RecordSource" VALUE="ToDoListBob"><PARAM
NAME="RecordsetLabel" VALUE="ToDoListBob|0 of |2;ToDoListBob|0-|1 of |2"><PARAM NAME="ShowFirstButton" VALUE="-1"><PARAM NAME="ShowPrevButton" VALUE="-1"><PARAM NAME="ShowNextButton" VALUE="-1"><PARAM NAME="ShowLastButton" VALUE="-1"><PARAM NAME="ShowNewButton" VALUE="-1"><PARAM NAME="ShowDelButton" VALUE="-1"><PARAM NAME="ShowSaveButton" VALUE="-1"><PARAM NAME="ShowUndoButton" VALUE="-1"><PARAM NAME="ShowSortAscendingBut
ton" VALUE="0"><PARAM NAME="ShowSortDecendingBut
ton" VALUE="0"><PARAM NAME="ShowApplyFilterButto
n" VALUE="0"><PARAM NAME="ShowToggleFilterButt
on" VALUE="0"><PARAM NAME="ShowHelpButton" VALUE="-1"><PARAM NAME="ShowLabel" VALUE="-1"><PARAM NAME="FontName" VALUE="Tahoma"></OBJECT>
<SCRIPT language=javascript event=onclick for=CommandSave>
try { if (MSODSC.DataPages.Count > 0)
if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).Save()
;
else
MSODSC.CurrentSection.Data
Page.Save(
); }
catch (e)
{ alert (e.description);}
</SCRIPT>
</DIV>
--------------------------
----------
----------
----------
----------
----------
----------
----------
-------
Can anyone spot anything that might be a problem with IE 7? Might this just a matter of upgrading Active X or Java?