MS Access ADODB.recordset character limit is 2036!? Can this be increased?

Posted by souper-dragon on Stack Overflow See other posts from Stack Overflow or by souper-dragon
Published on 2010-06-08T22:06:16Z Indexed on 2010/06/08 22:12 UTC
Read the original article Hit count: 246

Filed under:

ms-access-2007

|

adodb

|

recordset

In the following AccessVBA code, I am trying to write a record to a memo field called "Recipient_Display":

oRec1.Fields("RECIPIENT_DISPLAY") = Left(sRecipientDisplayNames, Len(sRecipientDisplayNames) - 2)

When the string contains 2036 characters, the write completes. Above this number I get the following error:

Run-time error'-2147217887(80040e21)': Could not update; currently locked by another session on this machine.

What is the significance of this number 2036 and is there a property I can adjust that will allow the above update to take place?

© Stack Overflow or respective owner

Related posts about ms-access-2007

remove autoexec macro from MS Access 2007

as seen on Stack Overflow - Search for 'Stack Overflow'
I have created an autoexec macro in MS Access 2007 and cannot find it! I know its there because it runs, but I cannot find it to delete or modify. I can see other macros that I have created just not the autoexec one. Can someone please point me in the right direction to find where it is located… >>> More
How to connect to MS Access 2007, from Java on a mac

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking for a way to connect to a MS Access 2007 database from Java. I don't believe the ODBC way is available to me as I'm writing on a mac and will be pushing this product to Linux. The HXTT drivers also do not work with 2007. Is there a way, a tutorial, an example, etc that accomplishes this… >>> More
Can't change data type on MS Access 2007

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi All, I have a huge database (800MB) which consists of a field called 'Date Last Modified' at the moment this field is entered as a text data type but need to change it to a Date/Time field to carry out some queries. I have another exact same database but with only 35MB of data inside it and when… >>> More
Help with Ms Access 2007 Combo boxes

as seen on Super User - Search for 'Super User'
What's the most efficient way to "chain" combo/boxes in an Access 2007 form, so that the result of the first affected the contents of the second? I already know how to associate a combo box on a form with a query. Here's a example of my scenario: cmbCarMake Behavior: User starts typing, and list… >>> More
MS-Access 2007 Time Online Report

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following data in my database: MemberID | DateTime ------------------------------------- 1 | 31/03/2010 3:45:49 PM 2 | 31/03/2010 3:55:29 PM 1 | 31/03/2010 4:45:49 PM Every time a user is authenticated or un-authenticated this log appears in the database… >>> More

Related posts about adodb

ADODB Connection String: Workgroup Information file is Missing?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a few data sources in access that I need to connect to programatically to do things with behind the scenes and keep visibility away from users. Said datasource has a password 'pass' as I'm going to call it here. Using this connection method I get an error attempting to use the open method Dim… >>> More
Using Server.CreateObject("ADODB.Stream") in IE7

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a asp.net 1.1 application that uses the following code to write out a file in the response: Dim objStream As Object objStream = Server.CreateObject("ADODB.Stream") objStream.open() objStream.type = 1 objStream.loadfromfile(localfile) Response… >>> More
unable to select correct ADODB version COM API

as seen on Stack Overflow - Search for 'Stack Overflow'
quick question is the public key token for ADODB dll different for 64bit and 32bit. I am trying to use a COM api which uses ADODB.Recordset and some how I am not able select the right version of ADODB in VS(2010) it asks for 2.8.0.0 and I add 2.8 from the reference dialog. The only thing I can think… >>> More
Brackets around Stored Procedure in ADODB Command Text

as seen on Stack Overflow - Search for 'Stack Overflow'
Help me understand why this is happening! I use the ADODB.Command object. The Command Text is set to the Stored Procedure Name. Sometimes, if I DON'T add brackets around the stored procedure name, I get a Syntax Error or Access Violation error. Sometimes, if I DO add brackets around the stored… >>> More
VBA - Create ADODB.Recordset from the contents of a spreadsheet

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am working on an Excel application that queries a SQL database. The queries can take a long time to run (20-40 min). If I've miss-coded something it can take a long time to error or reach a break point. I can save the results to a sheet fine, it's when I am working with the record sets that… >>> More