Hello all! I'm looking for real-world performance information for MS Access in terms of using text field vs. memo fields. I have a CF app using MS Access97 (just a couple of concurrent users on a busy day). Will be moving to Access2000 any day now, and maybe someday I'll get around to moving to MS SQL.
A number of fields in the various tables are text, and I've been wondering if changing them to memo would improve or decrease performance. The fields I'm thinking of changing to memo are not searched on or indexed, so that is not a concern. The length of data in those fields varies significantly, and so I end up defining a pretty large field size for them as text fields, although I heard once that the data is actually stored as variable length strings, and so defining large strings should not be a factor. Any experiences to relate? thanks, reed
