Current recordset does not support updating in vb6
If there are no records, the BOF and EOF property are True.As an Access developer — or even as a power user — you won't get far if you can't work with the Recordset object.But it's easy to go astray, and there are a number of mistakes that even experts make. Often, we're unaware of a subtle nuance between the two object libraries, Data Access Objects (DAO) and Active X Data Objects (ADO).No matter how experienced you are, it's difficult to commit every little behavior and requirement to memory.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).When both libraries are referenced and both libraries support an object, VBA will assign the library with the highest priority. Explicitly referencing each object's library when you declare the object is better: Combine #1 with #2 for the best results.
For more information on the upcoming change, we invite you to read our blog post.For example, fields deleted with the Delete method are marked for deletion immediately but remain in the collection.The Update method must be called to actually delete these fields from the provider's collection.This is perhaps a mistake ;-) The relevant bit of code is below: *********** Dim con Patient As Adodb.
OLEDB.4.0; Data Source=C:\Documents and Settings\Rik\Desktop\My VB\NHS\patient.mdb;" con Patient. It seems perfectly happy with the file *until* it reaches the Add New; the Move First and Move Next both show the correct records in the "watch" screen. Open "select * from patient" Hope this helps, Kieron PS. Occasionally, this may be all you need and it can save you the overhead of yet another object to track.Hi folks, I'm just starting out teaching myself VB, and so far have got on quite nicely with it. All help is very gratefully received; this has been doing my head in all day! Open SQL , dbase_connection, ad Open Dynamic, ad Lock Optimistic this is necessary to describe how to point to records (or something like that!! Look in MSDN for different values of Cursor Location, Type and Lock Type as to what is updatable or not Good Answer Stik. I'm coding a fairly simply database system; something to keep track of patients through a hospital unit. Many thanks, Rocko there possibly key elements missing = Cursor Location 'open the database to add new record conn. ) give that a whirl and see if it solves anything Hi, Your issue is that you need to specify a cursorlocation, cursortype and locktype on your recordset. Coupla minor points: You can do this is one line each for the Connection and recordset objects: 'Connect Call obj Conn. 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.