access link text field as memo

  • Thread starter Thread starter Andy Levy
  • Start date Start date
A

Andy Levy

Hi

I have a strange problem. I have two tables in a MySQL database. Both
tables have text type fields - however for one table access shows that the
field is of the 'text' type and the other table it shows it is of the 'memo'
type.

Has anyone got a clue as to how this can happen?


Thanks

Andy
 
Hi

I have a strange problem. I have two tables in a MySQL database. Both
tables have text type fields - however for one table access shows that the
field is of the 'text' type and the other table it shows it is of the 'memo'
type.

Has anyone got a clue as to how this can happen?
Click to expand...

I believe that if the size of the field is over 255 bytes Access will
define it as a Memo.
 
You must log in or register to reply here.

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

Data Type Issue in Linked Excel Table 7
Access 2010 query for 3 tables 0
Is it possible to link memo fields? 3
Formatting Memo Field Text 4
Relate words in memo/text field to another table 1
Memo type field size 7
Memo Field - Won't allow type 4
Memo Field in Table Truncated in query results and in report 1

Back
Top