Recordset ' recordset Dim b Mark As Variant ' variable to store bookmark I open the recordset with the statements, Set rst Food Desc = New ADODB. When I try to set a bookmark using, b Mark = rst Food Desc. The default data provider for the ADO Connection object is the Microsoft OLE DB Provider for ODBC.

Cursor Location = ad Use Client '------------------------------------------------------------------------ '---------------------- CONNECTION OPTION #3 ------------------------- '-------------------- OLE DB Provider to ODBC --------------------------- '------------------------------------------------------------------------ On Error Go To Err_NO_CONNECTION con I.

******* '- My SQL -- NO SUPPORT for Cursor Location = ad Use Server ----- '- ad Use Client will allow you to set your recordset to the current form ' Populate the temp table with the My SQL records con I.

Hello, I searched for the solution, but I couldn't find a clear answer.

This may be a limitaion of the provider, or the selected locktype." I have researched the locktype enum and the provider information.

I am getting a '3251' error "Current Recordset does not support updating.

Whether you like it or not, moving your thread to the correct place (and explaining why) is helping you to use the forums better, to increase your chances of getting help. if not then feel free to ask questions, as that is what I come here for (and what the vast majority of my posts are about).

but there are times when people decide to argue with us, and unfortunately the role of a moderator is basically a rule enforcer and peace keeper. It would have been better if you had worked it out yourself, but obviously it depends on whether you have read the forum descriptions or not - as they don't appear in the list of forums for searching etc, it is understandable to miss them. I'm hoping that the fact you have not posted anything about the issue since the initial post means you have solved it...

We definitely prefer not to do that, we would much rather be answering questions instead... not everyone is the mvp As I said in the second half of the sentence you quoted, your mistake was understandable - and I would far rather you hadn't decided to turn it into an argument, but that was entirely your choice.

'- OLE DB PROVIDER is considered obsolete by Microsoft from Carl Prothman '- Carl ---- Beautiful library of connection strings '------------------------------------------------------------------------ '---------------------- CONNECTION OPTION #1 ------------------------- '--------------ODBC FILEDSN connection using My ODBC Driver ------------ '------ File DSN files are Stored in a Data Source default directory --------- '------------------------------------------------------------------------ 'conn.