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

If you need more help, search this forum.

There have been lots of people wanting DB help.

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.