need help with Access 2000 *.mdb

This DB is being accessed using the Jet engine that comes with VB6. I can move through the DB and update the records, but I can't reliably add new records.

The coding is as follows;

DBFacilities.Recordset.AddNew
DBFacilities.Recordset.Edit
DBFacilities.Recordset.Fields.Append
DBFacilities.Recordset.Update

the third line was a desperation move.

right now all it does is update the last record.

Obviously, I am missing something simple, but....




Comments

  • When u cannot issue AddNew and Edit in the same time. AddNew would actually create a new records at EOF.

    : This DB is being accessed using the Jet engine that comes with VB6. I can move through the DB and update the records, but I can't reliably add new records.
    :
    : The coding is as follows;
    :
    : DBFacilities.Recordset.AddNew
    : DBFacilities.Recordset.Edit
    : DBFacilities.Recordset.Fields.Append
    : DBFacilities.Recordset.Update
    :
    : the third line was a desperation move.
    :
    : right now all it does is update the last record.
    :
    : Obviously, I am missing something simple, but....
    :
    :
    :
    :

    Neo Gigs
    http://communities.msn.com.my/VisualBasicwithNeo


  • : When u cannot issue AddNew and Edit in the same time. AddNew would actually create a new records at EOF.
    :
    : : This DB is being accessed using the Jet engine that comes with VB6. I can move through the DB and update the records, but I can't reliably add new records.
    : :
    : : The coding is as follows;
    : :
    : : DBFacilities.Recordset.AddNew
    : : DBFacilities.Recordset.Edit
    : : DBFacilities.Recordset.Fields.Append
    : : DBFacilities.Recordset.Update
    : :
    : : the third line was a desperation move.
    : :
    : : right now all it does is update the last record.
    : :
    : : Obviously, I am missing something simple, but....
    : :
    : :
    : :
    : :
    :
    : Neo Gigs
    : http://communities.msn.com.my/VisualBasicwithNeo
    :
    :


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories