table with Memo fields cannot be used in VB coding???

[Ariharan]

I have created a Database using MSacces in VisualData Manager of Visual Basic.The table contains 6 memo fields and 2 text fields.
The problem is now i cannot use this table in VB Coding.

Consider following coding

Set db=Opendatabase ("F:\new\qdb.md b")
Set rs=db.openrecor dset("select * from question")

The underlined code gives error "Type Mismatch".If I use a table without memo field it works good.But my project requires memo fields.Tell me the solution

[pureenhanoi]

I have created a Database using MSacces in VisualData Manager of Visual Basic.The table contains 6 memo fields and 2 text fields.
The problem is now i cannot use this table in VB Coding.

Consider following coding

Set db=Opendatabase ("F:\new\qdb.md b")
Set rs=db.openrecor dset("select * from question")

The underlined code gives error "Type Mismatch".If I use a table without memo field it works good.But my project requires memo fields.Tell me the solution

I've used Table with memo field (my table have number field, text field, datetime field and memo field) and get no error with "SELECT * FROM tableName".
Maybe, the error occures from another reason (ex: the declare of rs). If it was not, try creating database from Ms-Access instead of VisualData Manager