Current recordset does not support updating locktype
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 126.96.36.199 (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.