Problems wif database and applications

Hello!

I using visual basic 6 to do my application and using Microsoft Access 2000 as my database as file.

I need to get a certain number of fields in my database table in order to load the number of images out on to my application. Like for examples, i got 3 fields of data, i need to load 3 images... How can i go about in doing it?

Thanks.

What DB engine do you use(JET, ADO) ?

Hi

I using ADO.

Thanks.

Firstly sorry for the mistake. I meant DAO not JET. Because JET is most widespread OLEDB provider for MS Access.

You can do the following:

Set oCon = New Connection
oCon.Open sConnectionString

Dim rs As ADODB.Recordset
Set rs = oCon.OpenSchema(adSchemaColumns)

Do While Not rs.EOF
if rs!TABLE_NAME = "MyTable" Then
.... 'custom processing
End If
rs.MoveNext
Loop

set rs = Nothing
Set oCon = Nothing

Thanks Strannik for ur help...!


I will try to figure abt other coding...!