Run time error 3251 current recordset does not support updating

run time error 3251 current recordset does not support updating-61
Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.You'll be able to ask any tech support questions, or chat with the community and help others.

Tags: dating agencies onlinebest dating com adult personals online interracialclassical music lovers dating sitemd datingamerica american women and datingvideo dating serviceSexy pantyhose chat tvintelligent guys datingdating old singer sewing machines

This may be a limitation of the provider, or of the selected locktype.

It worked fine in Access, but when I switched to SQL Server it stopped working.

Im using the SQLOLEDB Provider and when Im trying to set the Index by using the code below i receive the ffg error...

Error 3251 : Current Provider does not support the necessary interface for Index functionality..

Here is the Dim strquery As String Dim cn As ADODB.

------------------------------------------ I've got another stored procedure in the same app that returns multiple recordsets and the code works.

Update ********* This looks ok to me; but the program doesn't like it. Add New line, it falls over, complaining: ********* Run time error '3251' Current Recordset does not support updating.

We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.

I have to use SQL Server as our Access databases are quite large...

Does the index and seek function even work with ADO and SQL Server 2000? I am migrating from DAO to ADO to use SQL Server and Im trying not to change the existing code so I need to use the Index and Seek functionality as it has been used everywhere...


Comments Run time error 3251 current recordset does not support updating

The Latest from ©