Current recordset does not support updating locktype

posted by | Leave a comment

Hi, My code is working just fine on my computer and I can update the access from my excel.

When trying to do the same from one of my user's computer, I get this error message: "Run-time error '3251': Current Recordset does not support updating.

Close Set o ADO = Nothing After you have that working, drop the usage of a DSN and change the code to o ADO.

I'm using Visual studio 2015 and Microsoft access 2016 Thanks in advance. The ADO Recordset object is used to hold a set of records from a database table.A Recordset object consist of records and columns (fields).User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)MIME-Version: 1.0Newsgroups: Advantage. OLEDBSubject: Current recordset does not support updating Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: .30Message-ID: X-Trace: -0700, .30Lines: 59Path: solutions.advantagedatabase.com! In a few places, we open a recordset and populate a grid. Open The updating part is like this: With adostatements . OLEDB:1154 Article PK: 1133675 My company is porting an application written in VB6 from Access to Advantage.

Leave a Reply

sex dating in sale creek tennessee