apexinternet
Programmer
what would cause the error when using an access database with ADO/ODBC
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record.
/admin/testform.asp, line 34
when using this query
Update results set Name='Barry Draper',Address='HC box 215 Davis Rd',City='Spring City',state='AK',Zip_Code='37381',Day_Phone='423-533-2473',Night_Phone='423-533-2473',Email='bmd721@aol.com',DOB='7/21/62',SSN='412-78-6793',Best_Time_to_Call='anytime',I_Prefer_to_Run_Southeast='Yes',I_Prefer_to_Run_Southwest='Yes',I_Prefer_to_Run_Northeast='Yes',I_Prefer_to_Run_Northwest='Yes',Class_CDL_Class_A='Yes',Drivers_School_Graduate='Yes',Experience_HHG='Yes',Experience_Flatbed='Yes',Experience_Van='Yes',Household_Goods_Experience='Yes',Owner_Operator_Number_of_Trucks_Owned=' ',Driving_Experience='1-3 yrs.',Years_with_Present_Carrier='6+ yrs.',Equipment_You_Presently_Operate_Make='international',Equipment_You_Presently_Operate_Year=' ',Tractor_Type='conventional',Trailer_Type='dry van',I_Prefer_to_Pull='flatbed',Like_to_Run_Single='Yes',Leasing_Buying_Carrier_Plan='Yes',Current_Employer=' ',Current_Employer_Address=' ',Current_Employer_Starting_Date=' ',Current_Employer_Phone=' ',Past_Employer_1='Enviorguard',Past_Employer_1_Address='W. Street',Past_Employer_1_Starting_Date='Jul-00',Past_Employer_1_Ending_Date='Dec-00',Past_Employer_1_Phone=' ',Past_Employer_2=' ',Past_Employer_2_Address=' ',Past_Employer_2_Starting_Date=' ',Past_Employer_2_Ending_Date=' ',Past_Employer_2_Phone=' ',Past_Employer_3=' ',Past_Employer_3_Address=' ',Past_Employer_3_Starting_Date=' ',Past_Employer_3_Ending_Date=' ',Past_Employer_3_Phone=' ',Past_Employer_4=' ',Past_Employer_4_Address=' ',Past_Employer_4_Starting_Date=' ',Past_Employer_4_Ending_Date=' ',Past_Employer_4_Phone=' ',Current_Drivers_License_State='TN',Current_Drivers_License_Number='50619257',Current_Drivers_License_Class='A',Current_Drivers_License_Endorsements='th',Current_Drivers_License_Exp_Date='7/21/02',Traffic_Convictions_1_Date=' ',Traffic_Convictions_1_City_State=' ',Traffic_Convictions_1_Charge=' ',Traffic_Convictions_1_Penalty=' ',Traffic_Convictions_2_Date=' ',Traffic_Convictions_2_City_State=' ',Traffic_Convictions_2_Charge=' ',Traffic_Convictions_2_Penalty=' ',Traffic_Convictions_3_Date=' ',Traffic_Convictions_3_City_State=' ',Traffic_Convictions_3_Charge=' ',Traffic_Convictions_3_Penalty=' ',Accident_Record_1_Date=' ',Accident_Record_1_City_State=' ',Accident_Record_1_Type_Accident=' ',Accident_Record_1_Preventable='Yes',Accident_Record_1_Fatalities=' ',Accident_Record_1_Injuries=' ',Accident_Record_2_Date=' ',Accident_Record_2_City_State=' ',Accident_Record_2_Type_Accident=' ',Accident_Record_2_Preventable='Yes',Accident_Record_2_Fatalities=' ',Accident_Record_2_Injuries=' ',Accident_Record_3_Date=' ',Accident_Record_3_City_State=' ',Accident_Record_3_Type_Accident=' ',Accident_Record_3_Preventable='Yes',Accident_Record_3_Fatalities=' ',Accident_Record_3_Injuries=' ',Felony_Conviction_Date=' ',Denied_License_Date=' ',License_Revoked_Date=' ',Reckless_Driving_Conviction_Date=' ',Conviction_Under_Influence_Date='1986',Sale_of_Controled_Substance='yes',Sale_of_Controled_Substance_Date=' ',Refused_Insurance_Bonding_Date=' ',Discharged_or_Suspended_Date=' ',Other_Comments=' ',DAC_Permission='Yes',Idemnification='By submitting this application I certify that I personally completed this application and that all of the information is true and correct. I hereby request and authorize Carrier Companies and their agents or contractors that receive this application to cause to be conducted, at any time, an investigation of my background for employment purposes, which may include, but is not limited to, any information relating to my character, general reputation, personal characteristics, mode of living, criminal history, past work experience, educational background, alcohol or drug test results, or failure to submit to an alcohol or drug test, or any other information about me which may reflect upon my potential for employment gathered from any individual, organization, entity, agency, or other source which may have knowledge concerning any such items of information. I also understand that my application will be added to you driver application database to be reviewed by carrier company recruiting agents. I have completed this application of my own free will and hold harmless of all liability all companies, agents and associated parties for the use of this application. I further understand eligibility for driver referral program consist of a minimum of ten complete refferal applications. As part of our consideration of your application, the DOT requires companies to investigate your employment background. As part of this investigation, they may obtain consumer reports about you from DAC Services. DAC is a consumer reporting agency. Any decision they make not to hire you based on information contained in your consumer report will be their decision alone. DAC does not make any decisions concerning your employment with these companies and will not know the specific reasons why they may decide not to hire you. In the event you are not hired based on information contained in your consumer report, the companies them selves will tell you. We will also advise you of your right to obtain a free copy of the consumer report from DAC and your right to dispute the accuracy or completeness of your report. Your consent for these companies to obtain the report from DAC is required. Although you have a right to withhold your consent, they will not consider your application if you do. I have read the above release and I give permission to obtain consumer reports about me from DAC.',status='hold' where id=1
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record.
/admin/testform.asp, line 34
when using this query
Update results set Name='Barry Draper',Address='HC box 215 Davis Rd',City='Spring City',state='AK',Zip_Code='37381',Day_Phone='423-533-2473',Night_Phone='423-533-2473',Email='bmd721@aol.com',DOB='7/21/62',SSN='412-78-6793',Best_Time_to_Call='anytime',I_Prefer_to_Run_Southeast='Yes',I_Prefer_to_Run_Southwest='Yes',I_Prefer_to_Run_Northeast='Yes',I_Prefer_to_Run_Northwest='Yes',Class_CDL_Class_A='Yes',Drivers_School_Graduate='Yes',Experience_HHG='Yes',Experience_Flatbed='Yes',Experience_Van='Yes',Household_Goods_Experience='Yes',Owner_Operator_Number_of_Trucks_Owned=' ',Driving_Experience='1-3 yrs.',Years_with_Present_Carrier='6+ yrs.',Equipment_You_Presently_Operate_Make='international',Equipment_You_Presently_Operate_Year=' ',Tractor_Type='conventional',Trailer_Type='dry van',I_Prefer_to_Pull='flatbed',Like_to_Run_Single='Yes',Leasing_Buying_Carrier_Plan='Yes',Current_Employer=' ',Current_Employer_Address=' ',Current_Employer_Starting_Date=' ',Current_Employer_Phone=' ',Past_Employer_1='Enviorguard',Past_Employer_1_Address='W. Street',Past_Employer_1_Starting_Date='Jul-00',Past_Employer_1_Ending_Date='Dec-00',Past_Employer_1_Phone=' ',Past_Employer_2=' ',Past_Employer_2_Address=' ',Past_Employer_2_Starting_Date=' ',Past_Employer_2_Ending_Date=' ',Past_Employer_2_Phone=' ',Past_Employer_3=' ',Past_Employer_3_Address=' ',Past_Employer_3_Starting_Date=' ',Past_Employer_3_Ending_Date=' ',Past_Employer_3_Phone=' ',Past_Employer_4=' ',Past_Employer_4_Address=' ',Past_Employer_4_Starting_Date=' ',Past_Employer_4_Ending_Date=' ',Past_Employer_4_Phone=' ',Current_Drivers_License_State='TN',Current_Drivers_License_Number='50619257',Current_Drivers_License_Class='A',Current_Drivers_License_Endorsements='th',Current_Drivers_License_Exp_Date='7/21/02',Traffic_Convictions_1_Date=' ',Traffic_Convictions_1_City_State=' ',Traffic_Convictions_1_Charge=' ',Traffic_Convictions_1_Penalty=' ',Traffic_Convictions_2_Date=' ',Traffic_Convictions_2_City_State=' ',Traffic_Convictions_2_Charge=' ',Traffic_Convictions_2_Penalty=' ',Traffic_Convictions_3_Date=' ',Traffic_Convictions_3_City_State=' ',Traffic_Convictions_3_Charge=' ',Traffic_Convictions_3_Penalty=' ',Accident_Record_1_Date=' ',Accident_Record_1_City_State=' ',Accident_Record_1_Type_Accident=' ',Accident_Record_1_Preventable='Yes',Accident_Record_1_Fatalities=' ',Accident_Record_1_Injuries=' ',Accident_Record_2_Date=' ',Accident_Record_2_City_State=' ',Accident_Record_2_Type_Accident=' ',Accident_Record_2_Preventable='Yes',Accident_Record_2_Fatalities=' ',Accident_Record_2_Injuries=' ',Accident_Record_3_Date=' ',Accident_Record_3_City_State=' ',Accident_Record_3_Type_Accident=' ',Accident_Record_3_Preventable='Yes',Accident_Record_3_Fatalities=' ',Accident_Record_3_Injuries=' ',Felony_Conviction_Date=' ',Denied_License_Date=' ',License_Revoked_Date=' ',Reckless_Driving_Conviction_Date=' ',Conviction_Under_Influence_Date='1986',Sale_of_Controled_Substance='yes',Sale_of_Controled_Substance_Date=' ',Refused_Insurance_Bonding_Date=' ',Discharged_or_Suspended_Date=' ',Other_Comments=' ',DAC_Permission='Yes',Idemnification='By submitting this application I certify that I personally completed this application and that all of the information is true and correct. I hereby request and authorize Carrier Companies and their agents or contractors that receive this application to cause to be conducted, at any time, an investigation of my background for employment purposes, which may include, but is not limited to, any information relating to my character, general reputation, personal characteristics, mode of living, criminal history, past work experience, educational background, alcohol or drug test results, or failure to submit to an alcohol or drug test, or any other information about me which may reflect upon my potential for employment gathered from any individual, organization, entity, agency, or other source which may have knowledge concerning any such items of information. I also understand that my application will be added to you driver application database to be reviewed by carrier company recruiting agents. I have completed this application of my own free will and hold harmless of all liability all companies, agents and associated parties for the use of this application. I further understand eligibility for driver referral program consist of a minimum of ten complete refferal applications. As part of our consideration of your application, the DOT requires companies to investigate your employment background. As part of this investigation, they may obtain consumer reports about you from DAC Services. DAC is a consumer reporting agency. Any decision they make not to hire you based on information contained in your consumer report will be their decision alone. DAC does not make any decisions concerning your employment with these companies and will not know the specific reasons why they may decide not to hire you. In the event you are not hired based on information contained in your consumer report, the companies them selves will tell you. We will also advise you of your right to obtain a free copy of the consumer report from DAC and your right to dispute the accuracy or completeness of your report. Your consent for these companies to obtain the report from DAC is required. Although you have a right to withhold your consent, they will not consider your application if you do. I have read the above release and I give permission to obtain consumer reports about me from DAC.',status='hold' where id=1