Inserting and deleting rows in table (Jet 3.0)

Question:
How can I add a row (recordset) so it gets inserted where it belongs, in alphabetical order? I use Jet 3.0, and when I update my database (.mdb), rows are inserted at the end.

Also, how can I delete a current row in my table? By “current,” I mean the one currently loaded by data control.

Answer:
I believe your question relates to Visual Basic and the Jet engine.Unfortunately, there is no way to insert a record with Visual Basic into any position other than the end.

You have two options:

1. Re-fetch all the data in sorted order after each insert, or
2. Switch to Oracle Power Objects, which has this functionality.

Charlie Frank

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.