Access 2000 Memo DataType - URGENT

Access 2000 Memo DataType - URGENT

Post by Craig Pearso » Sun, 11 Jun 2000 04:00:00


I am using an ADO Parameter Object to insert some text into a memo datatype
in Access 2000.  The ADO Command object which uses the Parameter Object
calls a Access 2000 query object.  Example below:

PARAMETERS prmCommentDesc Memo;
INSERT INTO Comment ( Comment )
VALUES (prmCommentDesc);

However the parameter datatype -  memo is not supported in query parameters
at the Access 2000 end.  Does any know what datatype I should using instead
of memo in the above query example?



1. Access 2000 memo datatype to JDBC

I'm trying to transfer an Access 2000 database to a Java based database
and I'd like to know what SQL or JDBC datatype to use for Access' Memo
type. Must I use the getUnicodeStream method or is there another method
I can use?


Sent via
Before you buy.

2. ODBC - VB4 Data Control

3. What datatype to use for Access memo fields?

4. ODBCExpress Questions.

5. Error while inserting memo datatype in Access

6. Creating a Repl over the internet

7. ADO and Access Memo datatypes

8. SQL7 Datatypes for Access memo fields

9. Convert Access memo datatype to SQL Server text type

10. Help needed: reading access 2000 memo fields

11. Access 2000 memo type fields don't display on my ASP pages

12. Importing Access memo fields to SQL Server 2000