
March 31st, 2004, 10:29 AM
|
|
Contributing User
|
|
Join Date: Feb 2001
Location: USA
Posts: 830
Time spent in forums: 3 h 17 m 56 sec
Reputation Power: 8
|
|
|
OLE object / large text fields in Microsoft Access
Access has a very annowing 64K limit on "memo" fields and the only thing I can see that might possibly be able to serve as a larger text field is the OLE object data type, but it's very mysterious to me. Can someone give me the short line on whether an OLE object field could be used to store a larger amount of plain text that could be retrieved using just an SQL query, or otherwise accessed through Coldfusion? E.g. not some elaborate solution involving ASP or ADO or DAO or any other impenetrable Microsoft technology.
|