Using OLEDB to manipulate .mdb files in VB.net

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
I have written several VB6 applications that use .mdb files. These applications use several 3rd party DLLs that will not run in Windows 7. After searching the web and forums on how to make these VB6 applications work in the .net environment,
I have decided to learn VB.net (using VB 2010 Express) and re-write these applications.

After reading 3 tech books and trying snippets to manipulate the existing .mdb files, it looks like I must use OLEDB commands; however I have yet to find how to Move 1st, Last, Next, Previous, Add, Delete, and Edit records in the .mdb tables. I want
to programatically do this with VB 2010 Express and not use the data base link properties of objects like DataGrid, DataView, Listbox, ComBobox, etc, or wizards. The only thing I have been able to achieve so far is to connect to the data base with OleDB.
I would appreciate snippets to manipulate the .mdb or links to code that do this.
Martin R P


View the full article
 
Back
Top