Still having problems connecting to my database

This looks like data access page, is it?

Try use ASP or ASP.net to connect, i think you can get way better support in this forum.


quote:Originally posted by pwtucker

Okay...here is my code (all of it is for one page, sorry for it being so much) and my ODBC setup on the ASP server. Can anyone give me a hand with connection to my database. It works fine from my machine, but no one else can connect. This is because it is still looking on my C:driver. Any help would be great.

this is the connection string I am using. I only know what half of this means:
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\web\bhamstreetl\htdocs\Database\bhamlights.mdb;User ID=bhamstreetl;Password=southern;Mode=Share Deny None;Extended Properties='';Persist Security Info=False;Jet OLEDB:System database='';Jet OLEDB:Registry Path='';Jet OLEDBatabase Password='';Jet OLEDB:Engine Type=0;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password='';Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>#13;#10; <a:MaxRecords>10000</a:MaxRecords>#13;#10; <a:GridX>24</a:GridX>#13;#10; <a:GridY>24</a:GridY>#13;#10; <a:OfflineType>2</a:OfflineType>#13;#10; <a:XMLLocation>0</a:XMLLocation>#13;#10; <a:XMLDataTarget></a:XMLDataTarget>#13;#10; <a:ConnectionFile></a:ConnectionFile>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>LightOwner</a:ElementID>#13;#10; <a:ControlSource>Light Owner</a:ControlSource>#13;#10; <a:ListRowSource>LightOwner_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Light_Owner</a:ListBoundField>#13;#10; <a:ListDisplayField>Light_Owner</a:ListDisplayField>#13;#10; <a:ChildLabel>LightOwner_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Status</a:ElementID>#13;#10; <a:ControlSource>Status</a:ControlSource>#13;#10; <a:ListRowSource>Status_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Status</a:ListBoundField>#13;#10; <a:ListDisplayField>Status</a:ListDisplayField>#13;#10; <a:ChildLabel>Status_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>GroupOfDate_Reported</a:ElementID>#13;#10; <a:ControlSource>GroupOfDate_Reported</a:ControlSource>#13;#10; <a:ChildLabel>GroupOfDate_Reported_Label</a:ChildLabel>#13;#10; <a:Format>Short Date</a:Format>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Problem_Type</a:ElementID>#13;#10; <a:ControlSource>Problem_Type</a:ControlSource>#13;#10; <a:ListRowSource>Problem_Type_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Problem_Type</a:ListBoundField>#13;#10; <a:ListDisplayField>Problem_Type</a:ListDisplayField>#13;#10; <a:ChildLabel>Problem_Type_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Explain_OtherProblem</a:ElementID>#13;#10; <a:ControlSource>Explain_Other Problem</a:ControlSource>#13;#10; <a:ChildLabel>Explain_OtherProblem_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Date_Repaired</a:ElementID>#13;#10; <a:ControlSource>Date_Repaired</a:ControlSource>#13;#10; <a:ChildLabel>Date_Repaired_Label</a:ChildLabel>#13;#10; <a:Format>Short Date</a:Format>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Repair_Action</a:ElementID>#13;#10; <a:ControlSource>Repair_Action</a:ControlSource>#13;#10; <a:ListRowSource>Repair_Action_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Repair_Action</a:ListBoundField>#13;#10; <a:ListDisplayField>Repair_Action</a:ListDisplayField>#13;#10; <a:ChildLabel>Repair_Action_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>ExplainOtherRepair</a:ElementID>#13;#10; <a:ControlSource>Explain Other Repair</a:ControlSource>#13;#10; <a:ChildLabel>ExplainOtherRepair_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Light_Number</a:ElementID>#13;#10; <a:ListRowSource>tblLightData</a:ListRowSource>#13;#10; <a:ListBoundField>Light_Number</a:ListBoundField>#13;#10; <a:ListDisplayField>Light_Number</a:ListDisplayField>#13;#10; <a:ChildLabel>Light_Number_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Light_Number1</a:ElementID>#13;#10; <a:ControlSource>Light_Number</a:ControlSource>#13;#10; <a:ChildLabel>Light_Number1_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>tblTroubleData-Date_ReportedNavLabel</a:ElementID>#13;#10; <a:RecordsetLabel>Record |0 of |2;tblTroubleData-Date_Reported |0-|1 of |2</a:RecordsetLabel>#13;#10; </a:ElementExtension>#13;#10; <a:GroupLevel>#13;#10; <a:RecordSource>tblLightData</a:RecordSource>#13;#10; <aefaultSort></aefaultSort>#13;#10; <a:HeaderElementId>HeadertblLightData</a:HeaderElementId>#13;#10; <a:FooterElementId></a:FooterElementId>#13;#10; <a:CaptionElementId></a:CaptionElementId>#13;#10; <a:RecordNavigationElementId></a:RecordNavigationElementId>#13;#10; <aataPageSize>-1</aataPageSize>#13;#10; <a:ExpandedByDefault/>#13;#10; <a:GroupFilterControl>Light_Number</a:GroupFilterControl>#13;#10; <a:GroupFilterField>Light_Number</a:GroupFilterField>#13;#10; <a:NoAllowEdits/>#13;#10; <a:NoAllowAdditions/>#13;#10; <a:NoAllowDeletions/>#13;#10; <a:AlternateRowColor>white</a:AlternateRowColor>#13;#10; </a:GroupLevel>#13;#10; <a:GroupLevel>#13;#10; <a:RecordSource>tblTroubleData-Date_Reported</a:RecordSource>#13;#10; <aefaultSort>[GroupOfDate_Reported]</aefaultSort>#13;#10; <a:HeaderElementId>HeadertblTroubleDataDateReported</a:HeaderElementId>#13;#10; <a:FooterElementId></a:FooterElementId>#13;#10; <a:CaptionElementId>CaptiontblTroubleDataDateReported</a:CaptionElementId>#13;#10; <a:RecordNavigationElementId>NavigationtblTroubleDataDateReported</a:RecordNavigationElementId>#13;#10; <aataPageSize>1</aataPageSize>#13;#10; <a:ExpandedByDefault/>#13;#10; <a:GroupFilterControl></a:GroupFilterControl>#13;#10; <a:NoAllowEdits/>#13;#10; <a:NoAllowAdditions/>#13;#10; <a:NoAllowDeletions/>#13;#10; <a:AlternateRowColor>white</a:AlternateRowColor>#13;#10; </a:GroupLevel>#13;#10; <a:GroupLevel>#13;#10; <a:RecordSource>tblTroubleData</a:RecordSource>#13;#10; <aefaultSort></aefaultSort>#13;#10; <a:HeaderElementId>HeadertblTroubleData</a:HeaderElementId>#13;#10; <a:FooterElementId></a:FooterElementId>#13;#10; <a:CaptionElementId></a:CaptionElementId>#13;#10; <a:RecordNavigationElementId></a:RecordNavigationElementId>#13;#10; <aataPageSize>-1</aataPageSize>#13;#10; <a:GroupFilterControl></a:GroupFilterControl>#13;#10; <a:NoAllowEdits/>#13;#10; <a:NoAllowAdditions/>#13;#10; <a:NoAllowDeletions/>#13;#10; <a:AlternateRowColor>white</a:AlternateRowColor>#13;#10; </a:GroupLevel>#13;#10; <aatamodel a:version="0816">#13;#10; <a:SchemaRowsource a:id="Repair_Action_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblRepairAction.Repair_Action FROM tblRepairAction; </a:CommandText>#13;#10; <a:SchemaField a:id="Repair_Action" a:datatype="202" a:size="50"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="Problem_Type_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblProblemType.Problem_Type FROM tblProblemType; </a:CommandText>#13;#10; <a:SchemaField a:id="Problem_Type" a:datatype="202" a:size="50"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="Status_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblStatus.Status FROM tblStatus; </a:CommandText>#13;#10; <a:SchemaField a:id="Status" a:datatype="202" a:size="50"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="LightOwner_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblLtOwner.Light_Owner FROM tblLtOwner; </a:CommandText>#13;#10; <a:SchemaField a:id="Light_Owner" a:datatype="202" a:size="50"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="tblLightData" a:type="dscTable">#13;#10; <a:SchemaField a:id="Light_Number" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Light Owner" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Status" a:datatype="130" a:size="50"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="tblTroubleData" a:type="dscTable">#13;#10; <a:SchemaField a:id="TroubleDataKey" a:datatype="3" a:size="0" a:iskey="1"/>#13;#10; <a:SchemaField a:id="Light_Number" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Date_Reported" a:datatype="7" a:size="0"/>#13;#10; <a:SchemaField a:id="Reported_By" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Assigned_To" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Date_Assigned" a:datatype="7" a:size="0"/>#13;#10; <a:SchemaField a:id="Problem_Type" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Explain_Other Problem" a:datatype="203" a:size="0"/>#13;#10; <a:SchemaField a:id="Repaired_By" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Date_Repaired" a:datatype="7" a:size="0"/>#13;#10; <a:SchemaField a:id="Repair_Action" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Explain Other Repair" a:datatype="203" a:size="0"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:RecordsetDef a:id="tblTroubleData">#13;#10; <aageField a:id="TroubleDataKey"/>#13;#10; <aageField a:id="Light_Number1" a:source="Light_Number"/>#13;#10; <aageField a:id="Date_Reported"/>#13;#10; <aageField a:id="Problem_Type"/>#13;#10; <aageField a:id="Explain_Other Problem"/>#13;#10; <aageField a:id="Date_Repaired"/>#13;#10; <aageField a:id="Repair_Action"/>#13;#10; <aageField a:id="Explain Other Repair"/>#13;#10; <a:GroupingDef a:id="tblTroubleData-Date_Reported">#13;#10; <aageField a:id="GroupOfDate_Reported" a:source="Date_Reported"#13;#10; a:groupon="dscEachValue" a:interval="1.0"/>#13;#10; </a:GroupingDef>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="tblLightData">#13;#10; <aageField a:id="Light_Number"/>#13;#10; <aageField a:id="Light Owner"/>#13;#10; <aageField a:id="Status"/>#13;#10; <a:Sublist a:relationship="Relationship1" a:sublist="tblTroubleData">#13;#10; <a:RelatedField arimary="Light_Number" a:foreign="Light_Number1"/>#13;#10; </a:Sublist>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="LightOwner_ListRowsource">#13;#10; <aageField a:id="Light_Owner"/>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="Status_ListRowsource">#13;#10; <aageField a:id="Status"/>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="Problem_Type_ListRowsource">#13;#10; <aageField a:id="Problem_Type"/>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="Repair_Action_ListRowsource">#13;#10; <aageField a:id="Repair_Action"/>#13;#10; </a:RecordsetDef>#13;#10; </aatamodel>#13;#10; </aataSourceControl>#13;#10;</xml>"></OBJECT>



ODBC on server at ASP.NET, but I would like to use a dsnless connection.
bhamstreetl_bhamdb \database\bhamlights.mdb

**********************************************************************************


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns =
"urn:schemas-microsoft-comfficeffice" xmlns:x =
"urn:schemas-microsoft-comffice:excel" xmlns:a =
"urn:schemas-microsoft-comffice:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>Enter New Lights</TITLE><LINK
href="EnterNewLights_files/filelist.xml" type=text/xml rel=File-List>
<META content=FrontPage.Editor.Document name=ProgId>
<META name=VBSForEventHandlers VALUE="TRUE">
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content=10.00.2225 name=DesignerVersion>
<META content="HTML 4.0" name=vs_targetSchema>
<OBJECT id=MSODSC tabIndex=-1
classid=CLSID:0002E553-0000-0000-C000-000000000046><PARAM NAME="XMLData" VALUE="<xml xmlns:a="urn:schemas-microsoft-comffice:access">#13;#10; <aataSourceControl>#13;#10; <a:OWCVersion>10.0.0.4109 </a:OWCVersion>#13;#10; <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=& server.mappath(\database\bhamlights.mdb) &;UserID=userid;Password=password;Mode=Share Deny None;Extended Properties="";Persist Security Info=False;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDBatabase Password="";Jet OLEDB:Engine Type=0;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>#13;#10; <a:MaxRecords>10000</a:MaxRecords>#13;#10; <a:GridX>24</a:GridX>#13;#10; <a:GridY>24</a:GridY>#13;#10; <a:OfflineType>2</a:OfflineType>#13;#10; <a:XMLLocation>0</a:XMLLocation>#13;#10; <a:XMLDataTarget></a:XMLDataTarget>#13;#10; <a:ConnectionFile></a:ConnectionFile>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Light_Number</a:ElementID>#13;#10; <a:ControlSource>Light_Number</a:ControlSource>#13;#10; <a:ChildLabel>Light_Number_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>LightOwner</a:ElementID>#13;#10; <a:ControlSource>Light Owner</a:ControlSource>#13;#10; <a:ListRowSource>LightOwner_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Light_Owner</a:ListBoundField>#13;#10; <a:ListDisplayField>Light_Owner</a:ListDisplayField>#13;#10; <a:ChildLabel>LightOwner_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Status</a:ElementID>#13;#10; <a:ControlSource>Status</a:ControlSource>#13;#10; <a:ListRowSource>Status_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Status</a:ListBoundField>#13;#10; <a:ListDisplayField>Status</a:ListDisplayField>#13;#10; <a:ChildLabel>Status_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>tblLightDataNavLabel</a:ElementID>#13;#10; <a:RecordsetLabel>|0 of |2;tblLightData |0-|1 of |2</a:RecordsetLabel>#13;#10; </a:ElementExtension>#13;#10; <a:GroupLevel>#13;#10; <a:RecordSource>tblLightData</a:RecordSource>#13;#10; <aefaultSort></aefaultSort>#13;#10; <a:HeaderElementId>HeadertblLightData</a:HeaderElementId>#13;#10; <a:FooterElementId></a:FooterElementId>#13;#10; <a:CaptionElementId></a:CaptionElementId>#13;#10; <a:RecordNavigationElementId>NavigationtblLightData</a:RecordNavigationElementId>#13;#10; <aataPageSize>1</aataPageSize>#13;#10; <a:GroupFilterControl></a:GroupFilterControl>#13;#10; <a:AlternateRowColor>whitesmoke</a:AlternateRowColor>#13;#10; </a:GroupLevel>#13;#10; <aatamodel a:version="0816">#13;#10; <a:SchemaRowsource a:id="LightOwner_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblLtOwner.Light_Owner FROM tblLtOwner; </a:CommandText>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="Status_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblStatus.Status FROM tblStatus; </a:CommandText>#13;#10; </a:SchemaRowsource>#13;#10; <a:RecordsetDef a:id="tblLightData">#13;#10; <aageField a:id="Light_Number"/>#13;#10; <aageField a:id="Light Owner"/>#13;#10; <aageField a:id="Status"/>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="LightOwner_ListRowsource">#13;#10; <aageField a:id="Light_Owner"/>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="Status_ListRowsource">#13;#10; <aageField a:id="Status"/>#13;#10; </a:RecordsetDef>#13;#10; </aatamodel>#13;#10; </aataSourceControl>#13;#10;</xml>"></OBJECT>
<META content="Microsoft FrontPage 5.0" name=GENERATOR>
<STYLE id=MSODAPDEFAULTS type=text/css>.MSTheme-Label {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: visible; BORDER-LEFT: 0px; WIDTH: 1in; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; HEIGHT: 0.156in; TEXT-ALIGN: left
}
.MsoTextbox {
PADDING-RIGHT: 3px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; WIDTH: 1in; FONT-FAMILY: Tahoma; HEIGHT: 0.197in
}
.MsoBoundSpan {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
.MsoHyperlinkDisplayText {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; CURSOR: hand; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
.Mso2dSection {
LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSection); OVERFLOW: hidden; POSITION: relative; TOP: 0px; BACKGROUND-COLOR: transparent
}
.Mso2dSectionBanner {
PADDING-RIGHT: 4px; DISPLAY: none; PADDING-LEFT: 4px; FONT-WEIGHT: normal; FONT-SIZE: 8pt; LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSectionBanner); OVERFLOW: visible; PADDING-TOP: 2px; FONT-FAMILY: Tahoma; TOP: 0px; HEIGHT: 0.2in; BACKGROUND-COLOR: buttonface
}
.MsoRectangle {
BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; OVERFLOW: hidden; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid
}
.MsoTitle {
DISPLAY: none; FONT-WEIGHT: normal; COLOR: inactivecaptiontext
}
.MsoExpandCollapse {
CURSOR: hand
}
.MsoNavContainer {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; Z-INDEX: -1; BORDER-LEFT: gainsboro 1px solid; CURSOR: hand; BORDER-BOTTOM: gainsboro 1px solid; HEIGHT: 25px; BACKGROUND-COLOR: gainsboro
}
.MsoNavButton {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; BORDER-LEFT: gainsboro 1px solid; CURSOR: auto; BORDER-BOTTOM: gainsboro 1px solid; BACKGROUND-REPEAT: no-repeat
}
.MsoNavButtonMouseOver {
BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid; BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid; BACKGROUND-COLOR: buttonhighlight
}
.MsoNavToggleButtonMouseOver {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; BACKGROUND-REPEAT: no-repeat; BACKGROUND-COLOR: buttonshadow
}
.MsoNavButtonMouseDown {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; BORDER-LEFT: buttonshadow 1px solid; CURSOR: hand; BORDER-BOTTOM: buttonshadow 1px solid; BACKGROUND-COLOR: buttonshadow
}
.MsoNavRecordsetLabel {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; PADDING-LEFT: 0px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: gainsboro 1px solid; WIDTH: 100%; CURSOR: default; PADDING-TOP: 0px; BORDER-BOTTOM: gainsboro 1px solid; FONT-FAMILY: Tahoma; POSITION: relative
}
.MsoRecordSelector {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; HEIGHT: 100%; BACKGROUND-COLOR: gainsboro
}
.MsoRecordSelectorCurrent {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url('owc://GIF/#11240'); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorSelectedImage {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url('owc://GIF/#11241'); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorSelected {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; LEFT: 0px; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; TOP: 0px; HEIGHT: 100%; BACKGROUND-COLOR: buttonshadow
}
.MsoRecordSelectorDirtyCurrent {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url('owc://GIF/#11242'); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorDirty {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url('owc://GIF/#11245'); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorTransparent {
LEFT: 0px; OVERFLOW: hidden; TOP: 0px
}
HR {
COLOR: black
}
SELECT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
INPUT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BODY {
FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
}
MARQUEE {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
LEGEND {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BUTTON {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
TEXTAREA {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
</STYLE>

<SCRIPT language=Javascript id=MSODSC_Validation>
validateBrowser();

function validateBrowser() {
strVers=navigator.appVersion
strName=navigator.appName
strPlat=navigator.platform
intIndex1=strVers.indexOf("MSIE");
intIndex1=intIndex1+5
intIndex2=strVers.lastIndexOf(";");
intVer=strVers.substring(intIndex1, intIndex2)
intVer=parseInt(intVer)
if (strName=="Microsoft Internet Explorer" && strPlat=="Win32" && intVer>="5") {
validateOWC();
}
else {
strMsgGetIE="<TABLE cellSpacing=0 cellPadding=0 width='95%' border=0 height='8'><TR>"
strMsgGetIE+="<TD bgColor='#336699' height=25 width=15> </TD><TD bgColor='#666666' width=500px><FONT face=Tahoma "
strMsgGetIE+="size=4 color=white> Data Access Page Notification</B></FONT></TD></TR>"
strMsgGetIE+="<TR><TD bgColor='#cccccc' width=15> </TD><TD bgColor='#cccccc' width=500px>"
strMsgGetIE+="<p><font face='Tahoma' size='2'>"
strMsgGetIE+="This page requires Windows IE 5.0 or higher.</p>"
strMsgGetIE+="<a href='http://www.microsoft.com/isapi/redir.dll?Prd=Office&Sbp=Access&Pver=10&Ar=DPdesigner&Sba=IEhome&Plcid=1033'><p align='center'>"
strMsgGetIE+="Click here to install the latest version of Internet Explorer.</a></font></p>
</TD></TR></TABLE>"
document.write(strMsgGetIE)
}
}

function validateOWC() {
if (MSODSC.object==null) {
strMsgGetOWC="<TABLE width='95%' cellpadding=0 cellspacing=0 border=0 height='8'>"
strMsgGetOWC+="<TR><TD bgColor='#336699' height=25 width=15> </TD><TD bgColor='#666666' width=500px>"
strMsgGetOWC+="<FONT face=Tahoma color=white size=4>  "
strMsgGetOWC+="Data Access Page Notification</B></FONT></TD></TR><TR><TD bgColor='#cccccc' width=15> </TD>"
strMsgGetOWC+="<TD bgColor='#cccccc' width='500px'>"
strMsgGetOWC+="<p><font face='Tahoma' size='2'>This page requires the Microsoft Office Web Components.</p>"
strMsgGetOWC+="</font><p><font face='Tahoma' size='2'>See the <a HRef='http://office.microsoft.com/office/redirect/10/MSOWCPub.asp?&HelpLCID=1033'>Microsoft Office Web site</a> for more information. "
strMsgGetOWC+="</font></p></TD></TR></TABLE>"
document.write(strMsgGetOWC)
}
}

</SCRIPT>
<!--[if gte mso 9]><xml>
<oocumentProperties>
<o:Author>Paul Tucker</o:Author>
<o:LastAuthor>Paul Tucker</o:LastAuthor>
<o:Revision>31</o:Revision>
<o:TotalTime>57</o:TotalTime>
<o:Created>2003-05-01T13:35:46Z</o:Created>
<o:LastSaved>2003-06-24T19:16:55Z</o:LastSaved>
<o:Company>Southern Company</o:Company>
<o:Version>10.4219</o:Version>
</oocumentProperties>
<o:OfficeDocumentSettings>
<oownloadComponents/>
<o:LocationOfComponents HRef="file:///\\"/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<SCRIPT language=JScript event=onload for=window>
try { if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).NewRecord();
else
MSODSC.CurrentSection.DataPage.NewRecord(); }
catch (e)
{ alert (e.description);}
<!--
-->
</SCRIPT>
</HEAD>

<H1 id=HeadingText align=center><FONT style="BACKGROUND-COLOR: #969696"
color=#cc0000>Enter New Lights</FONT></H1>
<P align=center><APPLET codeBase=..\ height=24 width=120 code=fphover.class><PARAM NAME="effect" VALUE="glow"><PARAM NAME="color" VALUE="#CC0000"><PARAM NAME="hovercolor" VALUE="#008080"><PARAM NAME="textcolor" VALUE="#FFFFFF"><PARAM NAME="url" VALUE="../index.htm"><PARAM NAME="text" VALUE="Home"></APPLET></P>
<DIV class=Mso2dSectionBanner id=HeadertblLightDataBanner
style="MARGIN-LEFT: 0px; WIDTH: 10.292in" tabIndex=-1>
<P align=center><SPAN id=HeadertblLightDataBannerCaption>Header:
tblLightData</SPAN></P></DIV>
<DIV class=Mso2dSection id=HeadertblLightData
style="VISIBILITY: inherit; MARGIN-LEFT: 0px; WIDTH: 10.292in; HEIGHT: 1.26in">
<P align=center><SPAN class=MSTheme-Label id=Light_Number_Label
style="FONT-WEIGHT: 700; LEFT: 3in; OVERFLOW: hidden; WIDTH: 96px; COLOR: black; POSITION: absolute; TOP: 0.083in; HEIGHT: 19px">Light
Number</SPAN><TEXTAREA class=MsoTextbox id=Light_Number style="FONT-WEIGHT: 700; Z-INDEX: 1; LEFT: 3in; WIDTH: 96px; COLOR: black; POSITION: absolute; TOP: 0.292in; HEIGHT: 19px" tabIndex=1 rows=1 MsoTextAlign="General" cols="20"></TEXTAREA><SPAN
class=MSTheme-Label id=LightOwner_Label
style="FONT-WEIGHT: 700; LEFT: 4.25in; OVERFLOW: hidden; WIDTH: 139px; COLOR: black; POSITION: absolute; TOP: 0.042in; HEIGHT: 19px">Light
Owner</SPAN><SELECT id=LightOwner
style="FONT-WEIGHT: 700; Z-INDEX: 2; LEFT: 4.26in; WIDTH: 1.475in; COLOR: black; POSITION: absolute; TOP: 0.292in; HEIGHT: 0.198in"
tabIndex=2><OPTION selected></OPTION></SELECT><SPAN class=MSTheme-Label
id=Status_Label
style="FONT-WEIGHT: 700; LEFT: 6in; OVERFLOW: hidden; WIDTH: 96px; COLOR: black; POSITION: absolute; TOP: 0.083in; HEIGHT: 19px">Status</SPAN><SELECT
id=Status
style="FONT-WEIGHT: 700; Z-INDEX: 3; LEFT: 6in; WIDTH: 1in; COLOR: black; POSITION: absolute; TOP: 0.292in; HEIGHT: 0.197in"
tabIndex=3><OPTION selected></OPTION></SELECT><FONT color=#cc0000>Add Record</FONT></BUTTON>
<SCRIPT language=javascript event=onclick for=cmdAdd>
try { if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).NewRecord();
else
MSODSC.CurrentSection.DataPage.NewRecord(); }
catch (e)
{ alert (e.description);}
</SCRIPT>
<FONT color=#cc0000>Delete
Record</FONT></BUTTON>
<SCRIPT language=javascript event=onclick for=cmdDelete>
try { if (MSODSC.DataPages.Count > 0)
if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).DeleteRecord();
else
MSODSC.CurrentSection.DataPage.DeleteRecord(); }
catch (e)
{ alert (e.description);}
</SCRIPT>
<FONT color=#cc0000>Save
Record</FONT></BUTTON>
<SCRIPT language=javascript event=onclick for=cmdSave>
try { if (MSODSC.DataPages.Count > 0)
if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).Save();
else
MSODSC.CurrentSection.DataPage.Save(); }
catch (e)
{ alert (e.description);}
try { if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).NewRecord();
else
MSODSC.CurrentSection.DataPage.NewRecord(); }
catch (e)
{ alert (e.description);}
</SCRIPT>
<FONT color=#cc0000>Undo
Record</FONT></BUTTON>
<SCRIPT language=javascript event=onclick for=cmdUndo>
try { if (MSODSC.DataPages.Count > 0)
if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).Undo();
else
MSODSC.CurrentSection.DataPage.Undo(); }
catch (e)
{ alert (e.description);}
</SCRIPT>

<P></P>
<DIV></DIV>
<P align=center> </P>
<P align=center> </P></DIV>
<DIV class=Mso2dSectionBanner id=NavigationtblLightDataBanner
style="MARGIN-LEFT: 0px; WIDTH: 10.292in" tabIndex=-1><SPAN
id=NavigationtblLightDataBannerCaption>Navigation: tblLightData</SPAN></DIV>
<DIV class=Mso2dSection id=NavigationtblLightData
style="VISIBILITY: inherit; MARGIN-LEFT: 0px; WIDTH: 10.292in; HEIGHT: 0.333in; BACKGROUND-COLOR: white">
<TABLE class=MsoNavContainer id=tblLightDataNavigation
style="LEFT: 288px; WIDTH: 384px; POSITION: absolute; TOP: 4px; HEIGHT: 24px"
cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavFirst id=tblLightDataNavFirst tabIndex=8 height=20
src="owc://GIF/#11200" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavPrevious id=tblLightDataNavPrevious tabIndex=9 height=20
src="owc://GIF/#11202" width=20></TD>
<TD style="VERTICAL-ALIGN: middle; WIDTH: 100%; TEXT-ALIGN: center"
noWrap><SPAN class=MsoNavRecordsetLabel id=tblLightDataNavLabel
style="VISIBILITY: hidden" tabIndex=10>|0 of |2</SPAN></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavNext id=tblLightDataNavNext tabIndex=11 height=20
src="owc://GIF/#11204" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavLast id=tblLightDataNavLast tabIndex=12 height=20
src="owc://GIF/#11206" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavSortAsc id=tblLightDataNavSortAscending tabIndex=17 height=20
src="owc://GIF/#11216" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavSortDesc id=tblLightDataNavSortDescending tabIndex=18
height=20 src="owc://GIF/#11218"
width=20></TD></TR></TBODY></TABLE></DIV></BODY></HTML>


</blockquote id="quote"></font id="quote">

 

Just to educate me, how is this page created? Did you use some kind of tool?

If i can get my hand on the tool, i may be able to help you.


quote:Originally posted by pwtucker

Okay...here is my code (all of it is for one page, sorry for it being so much) and my ODBC setup on the ASP server. Can anyone give me a hand with connection to my database. It works fine from my machine, but no one else can connect. This is because it is still looking on my C:driver. Any help would be great.

this is the connection string I am using. I only know what half of this means:
<a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=e:\web\bhamstreetl\htdocs\Database\bhamlights.mdb;User ID=bhamstreetl;Password=southern;Mode=Share Deny None;Extended Properties='';Persist Security Info=False;Jet OLEDB:System database='';Jet OLEDB:Registry Path='';Jet OLEDBatabase Password='';Jet OLEDB:Engine Type=0;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password='';Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>#13;#10; <a:MaxRecords>10000</a:MaxRecords>#13;#10; <a:GridX>24</a:GridX>#13;#10; <a:GridY>24</a:GridY>#13;#10; <a:OfflineType>2</a:OfflineType>#13;#10; <a:XMLLocation>0</a:XMLLocation>#13;#10; <a:XMLDataTarget></a:XMLDataTarget>#13;#10; <a:ConnectionFile></a:ConnectionFile>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>LightOwner</a:ElementID>#13;#10; <a:ControlSource>Light Owner</a:ControlSource>#13;#10; <a:ListRowSource>LightOwner_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Light_Owner</a:ListBoundField>#13;#10; <a:ListDisplayField>Light_Owner</a:ListDisplayField>#13;#10; <a:ChildLabel>LightOwner_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Status</a:ElementID>#13;#10; <a:ControlSource>Status</a:ControlSource>#13;#10; <a:ListRowSource>Status_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Status</a:ListBoundField>#13;#10; <a:ListDisplayField>Status</a:ListDisplayField>#13;#10; <a:ChildLabel>Status_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>GroupOfDate_Reported</a:ElementID>#13;#10; <a:ControlSource>GroupOfDate_Reported</a:ControlSource>#13;#10; <a:ChildLabel>GroupOfDate_Reported_Label</a:ChildLabel>#13;#10; <a:Format>Short Date</a:Format>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Problem_Type</a:ElementID>#13;#10; <a:ControlSource>Problem_Type</a:ControlSource>#13;#10; <a:ListRowSource>Problem_Type_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Problem_Type</a:ListBoundField>#13;#10; <a:ListDisplayField>Problem_Type</a:ListDisplayField>#13;#10; <a:ChildLabel>Problem_Type_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Explain_OtherProblem</a:ElementID>#13;#10; <a:ControlSource>Explain_Other Problem</a:ControlSource>#13;#10; <a:ChildLabel>Explain_OtherProblem_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Date_Repaired</a:ElementID>#13;#10; <a:ControlSource>Date_Repaired</a:ControlSource>#13;#10; <a:ChildLabel>Date_Repaired_Label</a:ChildLabel>#13;#10; <a:Format>Short Date</a:Format>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Repair_Action</a:ElementID>#13;#10; <a:ControlSource>Repair_Action</a:ControlSource>#13;#10; <a:ListRowSource>Repair_Action_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Repair_Action</a:ListBoundField>#13;#10; <a:ListDisplayField>Repair_Action</a:ListDisplayField>#13;#10; <a:ChildLabel>Repair_Action_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>ExplainOtherRepair</a:ElementID>#13;#10; <a:ControlSource>Explain Other Repair</a:ControlSource>#13;#10; <a:ChildLabel>ExplainOtherRepair_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Light_Number</a:ElementID>#13;#10; <a:ListRowSource>tblLightData</a:ListRowSource>#13;#10; <a:ListBoundField>Light_Number</a:ListBoundField>#13;#10; <a:ListDisplayField>Light_Number</a:ListDisplayField>#13;#10; <a:ChildLabel>Light_Number_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Light_Number1</a:ElementID>#13;#10; <a:ControlSource>Light_Number</a:ControlSource>#13;#10; <a:ChildLabel>Light_Number1_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>tblTroubleData-Date_ReportedNavLabel</a:ElementID>#13;#10; <a:RecordsetLabel>Record |0 of |2;tblTroubleData-Date_Reported |0-|1 of |2</a:RecordsetLabel>#13;#10; </a:ElementExtension>#13;#10; <a:GroupLevel>#13;#10; <a:RecordSource>tblLightData</a:RecordSource>#13;#10; <aefaultSort></aefaultSort>#13;#10; <a:HeaderElementId>HeadertblLightData</a:HeaderElementId>#13;#10; <a:FooterElementId></a:FooterElementId>#13;#10; <a:CaptionElementId></a:CaptionElementId>#13;#10; <a:RecordNavigationElementId></a:RecordNavigationElementId>#13;#10; <aataPageSize>-1</aataPageSize>#13;#10; <a:ExpandedByDefault/>#13;#10; <a:GroupFilterControl>Light_Number</a:GroupFilterControl>#13;#10; <a:GroupFilterField>Light_Number</a:GroupFilterField>#13;#10; <a:NoAllowEdits/>#13;#10; <a:NoAllowAdditions/>#13;#10; <a:NoAllowDeletions/>#13;#10; <a:AlternateRowColor>white</a:AlternateRowColor>#13;#10; </a:GroupLevel>#13;#10; <a:GroupLevel>#13;#10; <a:RecordSource>tblTroubleData-Date_Reported</a:RecordSource>#13;#10; <aefaultSort>[GroupOfDate_Reported]</aefaultSort>#13;#10; <a:HeaderElementId>HeadertblTroubleDataDateReported</a:HeaderElementId>#13;#10; <a:FooterElementId></a:FooterElementId>#13;#10; <a:CaptionElementId>CaptiontblTroubleDataDateReported</a:CaptionElementId>#13;#10; <a:RecordNavigationElementId>NavigationtblTroubleDataDateReported</a:RecordNavigationElementId>#13;#10; <aataPageSize>1</aataPageSize>#13;#10; <a:ExpandedByDefault/>#13;#10; <a:GroupFilterControl></a:GroupFilterControl>#13;#10; <a:NoAllowEdits/>#13;#10; <a:NoAllowAdditions/>#13;#10; <a:NoAllowDeletions/>#13;#10; <a:AlternateRowColor>white</a:AlternateRowColor>#13;#10; </a:GroupLevel>#13;#10; <a:GroupLevel>#13;#10; <a:RecordSource>tblTroubleData</a:RecordSource>#13;#10; <aefaultSort></aefaultSort>#13;#10; <a:HeaderElementId>HeadertblTroubleData</a:HeaderElementId>#13;#10; <a:FooterElementId></a:FooterElementId>#13;#10; <a:CaptionElementId></a:CaptionElementId>#13;#10; <a:RecordNavigationElementId></a:RecordNavigationElementId>#13;#10; <aataPageSize>-1</aataPageSize>#13;#10; <a:GroupFilterControl></a:GroupFilterControl>#13;#10; <a:NoAllowEdits/>#13;#10; <a:NoAllowAdditions/>#13;#10; <a:NoAllowDeletions/>#13;#10; <a:AlternateRowColor>white</a:AlternateRowColor>#13;#10; </a:GroupLevel>#13;#10; <aatamodel a:version="0816">#13;#10; <a:SchemaRowsource a:id="Repair_Action_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblRepairAction.Repair_Action FROM tblRepairAction; </a:CommandText>#13;#10; <a:SchemaField a:id="Repair_Action" a:datatype="202" a:size="50"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="Problem_Type_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblProblemType.Problem_Type FROM tblProblemType; </a:CommandText>#13;#10; <a:SchemaField a:id="Problem_Type" a:datatype="202" a:size="50"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="Status_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblStatus.Status FROM tblStatus; </a:CommandText>#13;#10; <a:SchemaField a:id="Status" a:datatype="202" a:size="50"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="LightOwner_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblLtOwner.Light_Owner FROM tblLtOwner; </a:CommandText>#13;#10; <a:SchemaField a:id="Light_Owner" a:datatype="202" a:size="50"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="tblLightData" a:type="dscTable">#13;#10; <a:SchemaField a:id="Light_Number" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Light Owner" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Status" a:datatype="130" a:size="50"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="tblTroubleData" a:type="dscTable">#13;#10; <a:SchemaField a:id="TroubleDataKey" a:datatype="3" a:size="0" a:iskey="1"/>#13;#10; <a:SchemaField a:id="Light_Number" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Date_Reported" a:datatype="7" a:size="0"/>#13;#10; <a:SchemaField a:id="Reported_By" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Assigned_To" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Date_Assigned" a:datatype="7" a:size="0"/>#13;#10; <a:SchemaField a:id="Problem_Type" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Explain_Other Problem" a:datatype="203" a:size="0"/>#13;#10; <a:SchemaField a:id="Repaired_By" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Date_Repaired" a:datatype="7" a:size="0"/>#13;#10; <a:SchemaField a:id="Repair_Action" a:datatype="130" a:size="50"/>#13;#10; <a:SchemaField a:id="Explain Other Repair" a:datatype="203" a:size="0"/>#13;#10; </a:SchemaRowsource>#13;#10; <a:RecordsetDef a:id="tblTroubleData">#13;#10; <aageField a:id="TroubleDataKey"/>#13;#10; <aageField a:id="Light_Number1" a:source="Light_Number"/>#13;#10; <aageField a:id="Date_Reported"/>#13;#10; <aageField a:id="Problem_Type"/>#13;#10; <aageField a:id="Explain_Other Problem"/>#13;#10; <aageField a:id="Date_Repaired"/>#13;#10; <aageField a:id="Repair_Action"/>#13;#10; <aageField a:id="Explain Other Repair"/>#13;#10; <a:GroupingDef a:id="tblTroubleData-Date_Reported">#13;#10; <aageField a:id="GroupOfDate_Reported" a:source="Date_Reported"#13;#10; a:groupon="dscEachValue" a:interval="1.0"/>#13;#10; </a:GroupingDef>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="tblLightData">#13;#10; <aageField a:id="Light_Number"/>#13;#10; <aageField a:id="Light Owner"/>#13;#10; <aageField a:id="Status"/>#13;#10; <a:Sublist a:relationship="Relationship1" a:sublist="tblTroubleData">#13;#10; <a:RelatedField arimary="Light_Number" a:foreign="Light_Number1"/>#13;#10; </a:Sublist>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="LightOwner_ListRowsource">#13;#10; <aageField a:id="Light_Owner"/>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="Status_ListRowsource">#13;#10; <aageField a:id="Status"/>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="Problem_Type_ListRowsource">#13;#10; <aageField a:id="Problem_Type"/>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="Repair_Action_ListRowsource">#13;#10; <aageField a:id="Repair_Action"/>#13;#10; </a:RecordsetDef>#13;#10; </aatamodel>#13;#10; </aataSourceControl>#13;#10;</xml>"></OBJECT>



ODBC on server at ASP.NET, but I would like to use a dsnless connection.
bhamstreetl_bhamdb \database\bhamlights.mdb

**********************************************************************************


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns =
"urn:schemas-microsoft-comfficeffice" xmlns:x =
"urn:schemas-microsoft-comffice:excel" xmlns:a =
"urn:schemas-microsoft-comffice:access" xmlns:dt =
"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882"><HEAD><TITLE>Enter New Lights</TITLE><LINK
href="EnterNewLights_files/filelist.xml" type=text/xml rel=File-List>
<META content=FrontPage.Editor.Document name=ProgId>
<META name=VBSForEventHandlers VALUE="TRUE">
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content=10.00.2225 name=DesignerVersion>
<META content="HTML 4.0" name=vs_targetSchema>
<OBJECT id=MSODSC tabIndex=-1
classid=CLSID:0002E553-0000-0000-C000-000000000046><PARAM NAME="XMLData" VALUE="<xml xmlns:a="urn:schemas-microsoft-comffice:access">#13;#10; <aataSourceControl>#13;#10; <a:OWCVersion>10.0.0.4109 </a:OWCVersion>#13;#10; <a:ConnectionString>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=& server.mappath(\database\bhamlights.mdb) &;UserID=userid;Password=password;Mode=Share Deny None;Extended Properties="";Persist Security Info=False;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDBatabase Password="";Jet OLEDB:Engine Type=0;Jet OLEDBatabase Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False</a:ConnectionString>#13;#10; <a:MaxRecords>10000</a:MaxRecords>#13;#10; <a:GridX>24</a:GridX>#13;#10; <a:GridY>24</a:GridY>#13;#10; <a:OfflineType>2</a:OfflineType>#13;#10; <a:XMLLocation>0</a:XMLLocation>#13;#10; <a:XMLDataTarget></a:XMLDataTarget>#13;#10; <a:ConnectionFile></a:ConnectionFile>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Light_Number</a:ElementID>#13;#10; <a:ControlSource>Light_Number</a:ControlSource>#13;#10; <a:ChildLabel>Light_Number_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>LightOwner</a:ElementID>#13;#10; <a:ControlSource>Light Owner</a:ControlSource>#13;#10; <a:ListRowSource>LightOwner_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Light_Owner</a:ListBoundField>#13;#10; <a:ListDisplayField>Light_Owner</a:ListDisplayField>#13;#10; <a:ChildLabel>LightOwner_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>Status</a:ElementID>#13;#10; <a:ControlSource>Status</a:ControlSource>#13;#10; <a:ListRowSource>Status_ListRowsource</a:ListRowSource>#13;#10; <a:ListBoundField>Status</a:ListBoundField>#13;#10; <a:ListDisplayField>Status</a:ListDisplayField>#13;#10; <a:ChildLabel>Status_Label</a:ChildLabel>#13;#10; </a:ElementExtension>#13;#10; <a:ElementExtension>#13;#10; <a:ElementID>tblLightDataNavLabel</a:ElementID>#13;#10; <a:RecordsetLabel>|0 of |2;tblLightData |0-|1 of |2</a:RecordsetLabel>#13;#10; </a:ElementExtension>#13;#10; <a:GroupLevel>#13;#10; <a:RecordSource>tblLightData</a:RecordSource>#13;#10; <aefaultSort></aefaultSort>#13;#10; <a:HeaderElementId>HeadertblLightData</a:HeaderElementId>#13;#10; <a:FooterElementId></a:FooterElementId>#13;#10; <a:CaptionElementId></a:CaptionElementId>#13;#10; <a:RecordNavigationElementId>NavigationtblLightData</a:RecordNavigationElementId>#13;#10; <aataPageSize>1</aataPageSize>#13;#10; <a:GroupFilterControl></a:GroupFilterControl>#13;#10; <a:AlternateRowColor>whitesmoke</a:AlternateRowColor>#13;#10; </a:GroupLevel>#13;#10; <aatamodel a:version="0816">#13;#10; <a:SchemaRowsource a:id="LightOwner_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblLtOwner.Light_Owner FROM tblLtOwner; </a:CommandText>#13;#10; </a:SchemaRowsource>#13;#10; <a:SchemaRowsource a:id="Status_ListRowsource" a:type="dscCommandText">#13;#10; <a:CommandText>SELECT tblStatus.Status FROM tblStatus; </a:CommandText>#13;#10; </a:SchemaRowsource>#13;#10; <a:RecordsetDef a:id="tblLightData">#13;#10; <aageField a:id="Light_Number"/>#13;#10; <aageField a:id="Light Owner"/>#13;#10; <aageField a:id="Status"/>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="LightOwner_ListRowsource">#13;#10; <aageField a:id="Light_Owner"/>#13;#10; </a:RecordsetDef>#13;#10; <a:RecordsetDef a:id="Status_ListRowsource">#13;#10; <aageField a:id="Status"/>#13;#10; </a:RecordsetDef>#13;#10; </aatamodel>#13;#10; </aataSourceControl>#13;#10;</xml>"></OBJECT>
<META content="Microsoft FrontPage 5.0" name=GENERATOR>
<STYLE id=MSODAPDEFAULTS type=text/css>.MSTheme-Label {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: visible; BORDER-LEFT: 0px; WIDTH: 1in; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; HEIGHT: 0.156in; TEXT-ALIGN: left
}
.MsoTextbox {
PADDING-RIGHT: 3px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; WIDTH: 1in; FONT-FAMILY: Tahoma; HEIGHT: 0.197in
}
.MsoBoundSpan {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
.MsoHyperlinkDisplayText {
BORDER-RIGHT: 0px; PADDING-RIGHT: 3px; BORDER-TOP: 0px; PADDING-LEFT: 3px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: 0px; CURSOR: hand; BORDER-BOTTOM: 0px; FONT-FAMILY: Tahoma; TEXT-ALIGN: left
}
.Mso2dSection {
LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSection); OVERFLOW: hidden; POSITION: relative; TOP: 0px; BACKGROUND-COLOR: transparent
}
.Mso2dSectionBanner {
PADDING-RIGHT: 4px; DISPLAY: none; PADDING-LEFT: 4px; FONT-WEIGHT: normal; FONT-SIZE: 8pt; LEFT: 0px; BEHAVIOR: url(#DEFAULT#Mso2dSectionBanner); OVERFLOW: visible; PADDING-TOP: 2px; FONT-FAMILY: Tahoma; TOP: 0px; HEIGHT: 0.2in; BACKGROUND-COLOR: buttonface
}
.MsoRectangle {
BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; OVERFLOW: hidden; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid
}
.MsoTitle {
DISPLAY: none; FONT-WEIGHT: normal; COLOR: inactivecaptiontext
}
.MsoExpandCollapse {
CURSOR: hand
}
.MsoNavContainer {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; Z-INDEX: -1; BORDER-LEFT: gainsboro 1px solid; CURSOR: hand; BORDER-BOTTOM: gainsboro 1px solid; HEIGHT: 25px; BACKGROUND-COLOR: gainsboro
}
.MsoNavButton {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; BORDER-LEFT: gainsboro 1px solid; CURSOR: auto; BORDER-BOTTOM: gainsboro 1px solid; BACKGROUND-REPEAT: no-repeat
}
.MsoNavButtonMouseOver {
BORDER-RIGHT: highlight 1px solid; BORDER-TOP: highlight 1px solid; BORDER-LEFT: highlight 1px solid; BORDER-BOTTOM: highlight 1px solid; BACKGROUND-COLOR: buttonhighlight
}
.MsoNavToggleButtonMouseOver {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; BACKGROUND-REPEAT: no-repeat; BACKGROUND-COLOR: buttonshadow
}
.MsoNavButtonMouseDown {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; BORDER-LEFT: buttonshadow 1px solid; CURSOR: hand; BORDER-BOTTOM: buttonshadow 1px solid; BACKGROUND-COLOR: buttonshadow
}
.MsoNavRecordsetLabel {
BORDER-RIGHT: gainsboro 1px solid; BORDER-TOP: gainsboro 1px solid; PADDING-LEFT: 0px; FONT-SIZE: 8pt; OVERFLOW: hidden; BORDER-LEFT: gainsboro 1px solid; WIDTH: 100%; CURSOR: default; PADDING-TOP: 0px; BORDER-BOTTOM: gainsboro 1px solid; FONT-FAMILY: Tahoma; POSITION: relative
}
.MsoRecordSelector {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; HEIGHT: 100%; BACKGROUND-COLOR: gainsboro
}
.MsoRecordSelectorCurrent {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url('owc://GIF/#11240'); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorSelectedImage {
BACKGROUND-POSITION: 1px 0px; BACKGROUND-IMAGE: url('owc://GIF/#11241'); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorSelected {
BORDER-RIGHT: buttonshadow 1px solid; BORDER-TOP: buttonshadow 1px solid; LEFT: 0px; OVERFLOW: hidden; BORDER-LEFT: buttonshadow 1px solid; BORDER-BOTTOM: buttonshadow 1px solid; TOP: 0px; HEIGHT: 100%; BACKGROUND-COLOR: buttonshadow
}
.MsoRecordSelectorDirtyCurrent {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url('owc://GIF/#11242'); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorDirty {
BACKGROUND-POSITION: -1px 0px; BACKGROUND-IMAGE: url('owc://GIF/#11245'); BACKGROUND-REPEAT: no-repeat
}
.MsoRecordSelectorTransparent {
LEFT: 0px; OVERFLOW: hidden; TOP: 0px
}
HR {
COLOR: black
}
SELECT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
INPUT {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BODY {
FONT-SIZE: 10pt; FONT-FAMILY: Tahoma
}
MARQUEE {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
LEGEND {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
BUTTON {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
TEXTAREA {
FONT-SIZE: 8pt; FONT-FAMILY: Tahoma
}
</STYLE>

<SCRIPT language=Javascript id=MSODSC_Validation>
validateBrowser();

function validateBrowser() {
strVers=navigator.appVersion
strName=navigator.appName
strPlat=navigator.platform
intIndex1=strVers.indexOf("MSIE");
intIndex1=intIndex1+5
intIndex2=strVers.lastIndexOf(";");
intVer=strVers.substring(intIndex1, intIndex2)
intVer=parseInt(intVer)
if (strName=="Microsoft Internet Explorer" && strPlat=="Win32" && intVer>="5") {
validateOWC();
}
else {
strMsgGetIE="<TABLE cellSpacing=0 cellPadding=0 width='95%' border=0 height='8'><TR>"
strMsgGetIE+="<TD bgColor='#336699' height=25 width=15> </TD><TD bgColor='#666666' width=500px><FONT face=Tahoma "
strMsgGetIE+="size=4 color=white> Data Access Page Notification</B></FONT></TD></TR>"
strMsgGetIE+="<TR><TD bgColor='#cccccc' width=15> </TD><TD bgColor='#cccccc' width=500px>"
strMsgGetIE+="<p><font face='Tahoma' size='2'>"
strMsgGetIE+="This page requires Windows IE 5.0 or higher.</p>"
strMsgGetIE+="<a href='http://www.microsoft.com/isapi/redir.dll?Prd=Office&Sbp=Access&Pver=10&Ar=DPdesigner&Sba=IEhome&Plcid=1033'><p align='center'>"
strMsgGetIE+="Click here to install the latest version of Internet Explorer.</a></font></p>
</TD></TR></TABLE>"
document.write(strMsgGetIE)
}
}

function validateOWC() {
if (MSODSC.object==null) {
strMsgGetOWC="<TABLE width='95%' cellpadding=0 cellspacing=0 border=0 height='8'>"
strMsgGetOWC+="<TR><TD bgColor='#336699' height=25 width=15> </TD><TD bgColor='#666666' width=500px>"
strMsgGetOWC+="<FONT face=Tahoma color=white size=4>  "
strMsgGetOWC+="Data Access Page Notification</B></FONT></TD></TR><TR><TD bgColor='#cccccc' width=15> </TD>"
strMsgGetOWC+="<TD bgColor='#cccccc' width='500px'>"
strMsgGetOWC+="<p><font face='Tahoma' size='2'>This page requires the Microsoft Office Web Components.</p>"
strMsgGetOWC+="</font><p><font face='Tahoma' size='2'>See the <a HRef='http://office.microsoft.com/office/redirect/10/MSOWCPub.asp?&HelpLCID=1033'>Microsoft Office Web site</a> for more information. "
strMsgGetOWC+="</font></p></TD></TR></TABLE>"
document.write(strMsgGetOWC)
}
}

</SCRIPT>
<!--[if gte mso 9]><xml>
<oocumentProperties>
<o:Author>Paul Tucker</o:Author>
<o:LastAuthor>Paul Tucker</o:LastAuthor>
<o:Revision>31</o:Revision>
<o:TotalTime>57</o:TotalTime>
<o:Created>2003-05-01T13:35:46Z</o:Created>
<o:LastSaved>2003-06-24T19:16:55Z</o:LastSaved>
<o:Company>Southern Company</o:Company>
<o:Version>10.4219</o:Version>
</oocumentProperties>
<o:OfficeDocumentSettings>
<oownloadComponents/>
<o:LocationOfComponents HRef="file:///\\"/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<SCRIPT language=JScript event=onload for=window>
try { if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).NewRecord();
else
MSODSC.CurrentSection.DataPage.NewRecord(); }
catch (e)
{ alert (e.description);}
<!--
-->
</SCRIPT>
</HEAD>

<H1 id=HeadingText align=center><FONT style="BACKGROUND-COLOR: #969696"
color=#cc0000>Enter New Lights</FONT></H1>
<P align=center><APPLET codeBase=..\ height=24 width=120 code=fphover.class><PARAM NAME="effect" VALUE="glow"><PARAM NAME="color" VALUE="#CC0000"><PARAM NAME="hovercolor" VALUE="#008080"><PARAM NAME="textcolor" VALUE="#FFFFFF"><PARAM NAME="url" VALUE="../index.htm"><PARAM NAME="text" VALUE="Home"></APPLET></P>
<DIV class=Mso2dSectionBanner id=HeadertblLightDataBanner
style="MARGIN-LEFT: 0px; WIDTH: 10.292in" tabIndex=-1>
<P align=center><SPAN id=HeadertblLightDataBannerCaption>Header:
tblLightData</SPAN></P></DIV>
<DIV class=Mso2dSection id=HeadertblLightData
style="VISIBILITY: inherit; MARGIN-LEFT: 0px; WIDTH: 10.292in; HEIGHT: 1.26in">
<P align=center><SPAN class=MSTheme-Label id=Light_Number_Label
style="FONT-WEIGHT: 700; LEFT: 3in; OVERFLOW: hidden; WIDTH: 96px; COLOR: black; POSITION: absolute; TOP: 0.083in; HEIGHT: 19px">Light
Number</SPAN><TEXTAREA class=MsoTextbox id=Light_Number style="FONT-WEIGHT: 700; Z-INDEX: 1; LEFT: 3in; WIDTH: 96px; COLOR: black; POSITION: absolute; TOP: 0.292in; HEIGHT: 19px" tabIndex=1 rows=1 MsoTextAlign="General" cols="20"></TEXTAREA><SPAN
class=MSTheme-Label id=LightOwner_Label
style="FONT-WEIGHT: 700; LEFT: 4.25in; OVERFLOW: hidden; WIDTH: 139px; COLOR: black; POSITION: absolute; TOP: 0.042in; HEIGHT: 19px">Light
Owner</SPAN><SELECT id=LightOwner
style="FONT-WEIGHT: 700; Z-INDEX: 2; LEFT: 4.26in; WIDTH: 1.475in; COLOR: black; POSITION: absolute; TOP: 0.292in; HEIGHT: 0.198in"
tabIndex=2><OPTION selected></OPTION></SELECT><SPAN class=MSTheme-Label
id=Status_Label
style="FONT-WEIGHT: 700; LEFT: 6in; OVERFLOW: hidden; WIDTH: 96px; COLOR: black; POSITION: absolute; TOP: 0.083in; HEIGHT: 19px">Status</SPAN><SELECT
id=Status
style="FONT-WEIGHT: 700; Z-INDEX: 3; LEFT: 6in; WIDTH: 1in; COLOR: black; POSITION: absolute; TOP: 0.292in; HEIGHT: 0.197in"
tabIndex=3><OPTION selected></OPTION></SELECT><FONT color=#cc0000>Add Record</FONT></BUTTON>
<SCRIPT language=javascript event=onclick for=cmdAdd>
try { if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).NewRecord();
else
MSODSC.CurrentSection.DataPage.NewRecord(); }
catch (e)
{ alert (e.description);}
</SCRIPT>
<FONT color=#cc0000>Delete
Record</FONT></BUTTON>
<SCRIPT language=javascript event=onclick for=cmdDelete>
try { if (MSODSC.DataPages.Count > 0)
if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).DeleteRecord();
else
MSODSC.CurrentSection.DataPage.DeleteRecord(); }
catch (e)
{ alert (e.description);}
</SCRIPT>
<FONT color=#cc0000>Save
Record</FONT></BUTTON>
<SCRIPT language=javascript event=onclick for=cmdSave>
try { if (MSODSC.DataPages.Count > 0)
if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).Save();
else
MSODSC.CurrentSection.DataPage.Save(); }
catch (e)
{ alert (e.description);}
try { if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).NewRecord();
else
MSODSC.CurrentSection.DataPage.NewRecord(); }
catch (e)
{ alert (e.description);}
</SCRIPT>
<FONT color=#cc0000>Undo
Record</FONT></BUTTON>
<SCRIPT language=javascript event=onclick for=cmdUndo>
try { if (MSODSC.DataPages.Count > 0)
if (MSODSC.CurrentSection == null)
MSODSC.DataPages(0).Undo();
else
MSODSC.CurrentSection.DataPage.Undo(); }
catch (e)
{ alert (e.description);}
</SCRIPT>

<P></P>
<DIV></DIV>
<P align=center> </P>
<P align=center> </P></DIV>
<DIV class=Mso2dSectionBanner id=NavigationtblLightDataBanner
style="MARGIN-LEFT: 0px; WIDTH: 10.292in" tabIndex=-1><SPAN
id=NavigationtblLightDataBannerCaption>Navigation: tblLightData</SPAN></DIV>
<DIV class=Mso2dSection id=NavigationtblLightData
style="VISIBILITY: inherit; MARGIN-LEFT: 0px; WIDTH: 10.292in; HEIGHT: 0.333in; BACKGROUND-COLOR: white">
<TABLE class=MsoNavContainer id=tblLightDataNavigation
style="LEFT: 288px; WIDTH: 384px; POSITION: absolute; TOP: 4px; HEIGHT: 24px"
cellSpacing=0 cellPadding=0>
<TBODY>
<TR>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavFirst id=tblLightDataNavFirst tabIndex=8 height=20
src="owc://GIF/#11200" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavPrevious id=tblLightDataNavPrevious tabIndex=9 height=20
src="owc://GIF/#11202" width=20></TD>
<TD style="VERTICAL-ALIGN: middle; WIDTH: 100%; TEXT-ALIGN: center"
noWrap><SPAN class=MsoNavRecordsetLabel id=tblLightDataNavLabel
style="VISIBILITY: hidden" tabIndex=10>|0 of |2</SPAN></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavNext id=tblLightDataNavNext tabIndex=11 height=20
src="owc://GIF/#11204" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavLast id=tblLightDataNavLast tabIndex=12 height=20
src="owc://GIF/#11206" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavSortAsc id=tblLightDataNavSortAscending tabIndex=17 height=20
src="owc://GIF/#11216" width=20></TD>
<TD class=MsoNavButton style="WIDTH: 20px; HEIGHT: 20px"><IMG
class=MsoNavSortDesc id=tblLightDataNavSortDescending tabIndex=18
height=20 src="owc://GIF/#11218"
width=20></TD></TR></TBODY></TABLE></DIV></BODY></HTML>


</blockquote id="quote"></font id="quote">