Help with MC ACESS insert please

Discussion in 'Programming' started by danjapro, Feb 26, 2009.

  1. #1
    Help with this Statement it works in SQL but not for ACCESS:

    sql = "insert into PLAN.[plan] (name, price, PLAN.[desc], feature_post_profile, feature_view_profile, feature_upload_photo, feature_upload_video, feature_upload_audio, feature_quick_search, feature_detailed_search, feature_save_search, feature_add_favorites, feature_send_messages, feature_receive_messages, feature_chat, feature_more_photo, paypal, length) values ('" & name & "', " & price & ", '" & desc & "', 0" & feature_post_profile & ", 0" & feature_view_profile & ", 0" & feature_upload_photo & ", 0" & feature_upload_video & ", 0" & feature_upload_audio & ", 0" & feature_quick_search & ", 0" & feature_detailed_search & ", 0" & feature_save_search & ", 0" & feature_add_favorites & ", 0" & feature_send_messages & ", 0" & feature_receive_messages & ", 0" & feature_chat & ", 0" & feature_more_photo & ", '" & paypal & "', 0" & length & ")"
    Code (markup):
     
    danjapro, Feb 26, 2009 IP