I have created an application in vb.net. where i have used all / every way to transfer data to an access database. Download the code and you will be amazed to know that the recordset is the fastest of them all. If RecordSet is the fastest then why did ADO.NET come into existance. Any reason why do we use dataset over recordset(disconnected).
If anyone is able to find a faster code than this please let me know. But do remember to only use ado.net or ado.
Please find DBTest_VS2003 file attached.
Best of Luck to all !!