How to use DataBase

[zawpai]

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

[choudhuryshouvi]

You can Visit THis LInk

[zawpai]

Hi choudhuryshouvi,

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

Regards,
zawpai

[bushman_222]

If you need more help, search this forum.

There have been lots of people wanting DB help.

[Jx_Man]

yup, post your problem if find some understanding :)
happy coding friend :)

[zawpai]

Hi all,

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

Best Regards,
zawpai

[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