Visual Basic/VB, looking for direction

looking for direction

Author	Message
Tony Perkin #1 / 4	looking for direction how would i go about storing a large amount of text. for example i need to design an interface that will allow for data entery on customers. the problem i am having is that there needs to be a comments section. this section can get quite lengthy. i only have ms access 2000 databases at my disposel. the amount that needs to be entered exceeds the 255 character limit for one field. i will need to retreive this information on a regualar basis any ideas would be greatly appreciated tony
Mon, 29 Dec 2003 02:01:52 GMT

Adrian Batema #2 / 4	looking for direction Hi Tony, You can use a memo field in Access for longer text fields. From the docs: In general, text fields can be up to 255 characters, while memo fields can be up to 65,535 characters, but if the memo field does not contain any binary data, then its only limit is the maximum size of the database (approximately 2.14GB or 1,070,000,000 Unicode characters). In addition, unused portions of text fields are not reserved in memory. Regards, Ade. Quote: > how would i go about storing a large amount of text. for example i need to > design an interface that will allow for data entery on customers. the > problem i am having is that there needs to be a comments section. this > section can get quite lengthy. i only have ms access 2000 databases at my > disposel. the amount that needs to be entered exceeds the 255 character > limit for one field. i will need to retreive this information on a regualar > basis > any ideas would be greatly appreciated > tony
Mon, 29 Dec 2003 02:16:51 GMT

Sergey Kat #3 / 4	looking for direction You can store large text data in field with Memo data type, I think it has 64k limit. Then use rs!YourField.GetChunk() and rs!YourField.AppendChunk() to retrieve and store data. - Sergey Quote: > how would i go about storing a large amount of text. for example i need to > design an interface that will allow for data entery on customers. the > problem i am having is that there needs to be a comments section. this > section can get quite lengthy. i only have ms access 2000 databases at my > disposel. the amount that needs to be entered exceeds the 255 character > limit for one field. i will need to retreive this information on a regualar > basis > any ideas would be greatly appreciated > tony
Mon, 29 Dec 2003 02:23:35 GMT

Tony Perkin #4 / 4	looking for direction thanks a lot to both of you. that is exactly what im looking for. Quote: > how would i go about storing a large amount of text. for example i need to > design an interface that will allow for data entery on customers. the > problem i am having is that there needs to be a comments section. this > section can get quite lengthy. i only have ms access 2000 databases at my > disposel. the amount that needs to be entered exceeds the 255 character > limit for one field. i will need to retreive this information on a regualar > basis > any ideas would be greatly appreciated > tony
Mon, 29 Dec 2003 03:25:17 GMT

Page 1 of 1

[ 4 post ]