ADO and Array

[mml]

Hi,
New member here, also very new to VB. I am currently working on an application that reads and writes records from an .mdb file to an array. I am using an Active X control (ADO). I can't seem to write to the file and also can't seem to get the recordsets to display in the array. Have checked the connections, have bound the controls, have assigned the recordsource to the ADO control, plus a number of other things (including begging it to work!!). I am a bit stumped here as to where the problem lies. Maybe someone could help? At least point me in the direction as to where to begin to fix this problem. Will be more than happy to supply code, but don't know if it needs to come from the enter or load or neither?

I really need some assistance here, can anybody help? Please? Greatly appreciative!!!!

mml

[makai]

this shows how to but data in a DBListbox
http://pages.about.com/vbmakai/ado4.htm

from the listbox it is easy to get it into an array

but if you really want to directly populate an array, you would normally open the database in code, loop through the records and take what you want from the fields

I'll show you the fastest way


dim rs as new ADODB.Recordset,cn as new ADODB.Connection
Dim varResult as variant,strConn as string

strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Persist Security Info=False;" & _
"Data Source=" & App.Path + "\KoordNeu.mdb"

cn.Open strConnect
rs.open "Select * from Table",cn, adOpenStatic, adLockReadOnly

varResult=rs.Getrows
rs.close
set rs=nothing
set cn=nothing

varResult is a array with all Data from the Recordset