Ack! Why can't I add info to my Access file!

Results 1 to 2 of 2

Thread: Ack! Why can't I add info to my Access file!

  1. #1
    Join Date
    Dec 1969
    Posts
    538

    Default Ack! Why can't I add info to my Access file!

    I get this weird message:<BR><BR>"ADODB.Field error &#039 800a0cb3&#039 <BR><BR>The operation requested by the application is not supported by the provider. <BR><BR>/ynz/opt.asp, line 144 "<BR><BR>Near line 144 I have:<BR><BR>sum = objrs("points") + 1<BR><BR>And here&#039s line 144:<BR><BR>objrs("points") = sum<BR><BR>I get this everytime I try to change the recordset values. For example, I cannot do this:<BR><BR>objrs("gamerstatus") = "dead"<BR><BR>...either. What can I do? Help!!!

  2. #2
    pnub Guest

    Default RE: Ack! Why can't I add info to my Access fi

    The syntax for adding/changing fields in an Access Database would be as follows (following your examples):<BR><BR>sum = objrs.Fields("points") + 1<BR><BR>objrs.Fields("points") = sum<BR><BR>objrs("gamerstatus") = "dead"<BR><BR>Hopefully that helps you out!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •