I am working with ".mdb" file & DAO successfully (VB6).
But for 2 problem I have to work with SQL I think.
_1. data security
_2. using more PC with same database.
_and also 3. using large database

Now I cannot start programing with SQL(SQL 2000) from VB6.
I need ......
__(1) code to store a data (a row) to SQL database
__(2) code view data (a row) from SQL database
using any Connection method & Provider, what is best for me for Data security & using lan networking.