Hi all,

I need to get some data from an Access database, I'm using this:

mdbfilename = "d:\max\conversions\cec\them\as3snapshot.mdb"

oVFPCOM = CreateObject("vfpcom.comutil")

oRecordSet = CreateObject('ADODB.RECORDSET')
oRecordSet.CursorType = 3 && adOpenStatic Also adOpenForwardOnly
oRecordSet.LockType = 1   && adLockReadOnly

loConn = createobject('ADODB.Connection')
loConn.open("Provider = Microsoft.JET.OLEDB.4.0;" + ;
			"Data Source = " + mdbfilename)
oRecordSet.ActiveConnection = loConn
oRecordSet.Open('SELECT * FROM AILSRAC1100')

nError = oVFPCOM.RSToCursor(oRecordSet, 'mycursor')

BROWSE

...It works, but all fields in the cursor are type general and empty :(
I used MDB2VFP from John Kozoil but it's too slow for this 100000 plus recors per table database.
I'm using MDAC 2.7.

Max