Re: Memo fields in Access

In article <43mnlc$da5@aztec.co.za> storm@aztec.co.za "Storm Software" writes: > Recently we had to write a central database that mimicked all of > the sales databases on a sales force's laptops. The central database > was Informix and of course, the local stuff was Access. > > Everything worked fine except for the Access Memo field. Given a few > choices (var char, blob, chopping it into chars), can anybody make > suggesstions on how best to share information across these two databases > and these data types. > > We had a slight problem in that our customer could only afford SE, > but what to do generally? So, I guess you chopped it into chars, then? I personally have very little Access experience, but I'd imagine a TEXT field would be best (on Online). HTH, Spokey the Wheeler------------------------------------------------------------- "Billy Boy" - das aufregend andere kondom! Carter - the Unstoppable Sex Machine / Wheeler - the Unstoppable Mail Machine!