Insert/update memos using RunSQL

N

nermal

Hi

I'm wish to use unbound forms so as not to trash my tables directly.

I wish to run INSERT/UPDATE SQL statements on my Access 97 tables.

Everything works fine except for MEMO fields which get truncated to 255
characters. I've searched high and low on the internet and can find no
solution to this problem.

Is there a way of inserting/updating a string greater than 255 characters
using RunSQL???

Cheers
Richard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert/update of MEMO data using RunSQL 0
insert memo feild into a memo field truncates at 255 characters - 4
Truncation of memo fields using DoCmd.TransferText acImportDelim, 1
Problems saving record to a SQL Server via VBA 4
form won't update, what to check 2
255 Character Limit for Linked Excel data 1
Memo field truncated from form to table 4
How do I prevent data truncation from access to excel using MS Qu. 1

Top