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 trying to add around 4kb of data to a test database and are coming up with and error from ODBC. It corrupts the database, too.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Question on Memo field limitations
- Thread starter ephil
- Start date
- Thread starter
- #2
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 documented here as being not a good situation and will result in a corrupt database.
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 documented here as being not a good situation and will result in a corrupt database.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question