Hi all,

I haven't used 'Data Base' in VB 6.0. Now, I would like to create small data base with microsoft access 2003 for testing. Could anyone please give me some guidelines to do this or give me some good link to start to lean?

Best Regards,
zawpai

Hi choudhuryshouvi,

Thank you for giving a good link. I will try to understand about data base.

Regards,
zawpai

Hi all,

Thanks a lot.
If I have some problems about it, I will let you know.

Best Regards,
zawpai

Hi choudhuryshouvi,

I start to read the link that you gave me. But, I can't run that sample program and get one error, Compile error "Method or data member not found". I also don't know how to create it, SQL select * from authors , in application one.

http://www.vb6.us/tutorials/database-access-ado-vb6-tutorial#SAMP_APP_1

This is the sample program:

Private Sub cmdIDOrder_Click()
adoBiblio.SQL = "select * from authors order by au_id"
adoBiblio.Refresh
End Sub

Private Sub cmdNameOrder_Click()
adoBiblio.SQL = "select * from authors order by author"
adoBiblio.Refresh
End Sub

Private Sub cmdYearOrder_Click()
adoBiblio.SQL = "select * from authors order by [year born]"
adoBiblio.Refresh
End Sub


An error message is from "adoBiblio.SQL"

Pls explain me where the error is.

Best Regards,
zawpai

This article has been dead for over six months. Start a new discussion instead.