Memo field and Insert Into vb6 and mdb

[BBBane]

Thank You for the replay.
No it's not called Table,I just wanted to avoid meaningless names (for others)...
Yes,I tried using adVarChar and got an error "invalid precision value"....
That's why I started using adLongVarChar...

Now I don't know if this may be the case,but just to be sure...
I'm using If statements,and after the first Insert Into is done I set do this

Set CatComm = Nothing

and before it starts with another Insert statement

Set CatComm = New ADODB.Command

There should be nothing wrong with SQL statements,I only receive errors on memo fields...

And I found on internet that adVarChar can store up to 250 characters?
Thank You.