Urgent Help!!How to Connect Microsoft Access Database to VB6

[Elagirly]

Hi..
Im a beginner in this forum. I badly needed help. I have created a seperate database using microsoft access and i wanted to connect it to the Sample program I have created using Visual Basic.

Im not familiar with the codes here in VB. Please help me in the simplest possible way. (laymen's term). Im as well a beginner in programming.

Hope for assistance the soonest.

Thanks

[jeranio]

Hi I was having same problem . Try this

Dim dbMain As Database (this declares variable to hold DB)

Set dbMain = OpenDatabase("rent.mdb") (this actually opens DB)

Set RSJobCards = dbMain.OpenRecordset("jobcards", dbOpenDynaset) This will open the "jobcards" table in database called RENT.MDB

If you have no joy email me at jeranio@iburst.co.za
ALSO LEARNING BUT QUICK