Well, we just figured it out. It points out a loop-hole in the Access interface that allows Memo fields to end up indexed.
1. Add an indexed text field to a table
2. Change the data type to Memo
3. From the menu, select View | Indexes
You will see the field is still indexed, which is well...
In faq700-4188 it says that if a memo field is manipulated through DAO, the size of the memo field is limited by the size of the database. Does this mean that if a database has only one record in it (600kb) and one of the fields is a memo field, you can't put very much text in it? We are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.