-
December 23rd, 1999, 05:27 AM
#1
Update error
When I try to update a record I get the message:
"[Microsoft][ODBC Microsoft Access Driver] The search key was not found in any record". I'm using ADO and this message apears only when I modify a memo field which contains 500 chars.
What could be the problem? Please help me with some sugestions. Thanks
-
December 26th, 1999, 05:22 AM
#2
Re: Update error
Not sure about this, but it is best to find out the limitation of Access on the number of characters allowed for a field. As I recall, I think for text fields (the text datatypes) the limit is 255 characters... so check it out with Access first!
Hope this points you in the right direction for debugging purposes...
____________________________________
The VB Bugs in my Life...
-
December 27th, 1999, 01:10 AM
#3
Re: Update error
Thanks, but it's not that. I have a memo field which can hold up to 32K of char. The corresponding field in the form is a multiline TextBox.
I'm really blocked now.
-
December 28th, 1999, 01:41 AM
#4
Re: Update error
try cheking whether the field names are correct,table name is correct and whether ur odbc is installed properly..
-
December 28th, 1999, 03:19 AM
#5
Re: Update error
Try to use GetChunk/AppendChunk method. They are designed for work with MEMO fields.
[ufo]
-
December 29th, 1999, 03:27 AM
#6
Re: Update error
That's a good idea. I'll try it.
Thanx.
-
December 29th, 1999, 05:13 AM
#7
Re: Update error
It didn't work. I receive the same message. Any other idea?
-
December 29th, 1999, 05:20 AM
#8
Re: Update error
What about primary key in your recordset ? Without primary key you can't update through recordset. Try to open recordset with column which is in background table as primary key.
[ufo]
-
December 29th, 1999, 08:44 AM
#9
Re: Update error
I have a primary key. An AutoNumber. If the number of characters within the memo field in not larger than ?? (I didn't find out the limit), the update works OK. I tryed to update a record when the memo field had 1000 chars and it worked. But if the memo field has 2000 char and I erase one char even, the update doesn't work. Also I don't have the problem when I add a new record. Even if the memo field has 15000 chars.
I hope is not a bug in the driver. I searched for the error message at microsoft.com and I didn't find it.
I'm desperate.
-
January 3rd, 2000, 05:24 AM
#10
Re: Update error
All of that is correct. The update works OK if the fields has, let's say, 100 characters.
Thanx anyway. Any other idea?
-
January 3rd, 2000, 11:14 AM
#11
Re: Update error
OK, send me some more information and I will see what to do.
1. connection string ?
2. version of MDAC on your machine ?
However, I can ask some people from private beta newsgroup regarding this and if it's bug I will have patch or something.
[ufo]
-
January 4th, 2000, 04:35 AM
#12
Re: Update error
lConnection.CursorLocation = adUseClient
lConnection.ConnectionString=PROVIDER=MSDASQL;dsn=find2;uid=;pwd=;
adoPrimaryRS.Open sqlString, lConnection,
adOpenDynamic, adLockPessimistic
I use Microsoft ActiveX Data Objects 2.1 Library.
On the form I have a multiline TextBox with the DataField property set to my database memo field.
Thank you again for your help.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|