No subject

There are two kinds of strings: variable-length and fixed-length strings.
A variable-length string can contain up to approximately 2 billion (2^31)
characters.
A fixed-length string can contain 1 to approximately 64K (2^16) characters.

In a application I use a text file is placed into a string variable defined
by
Public myString as String.

 I was under the impression that this line defined a variable length
string, but ran into a text file of approximately 5mb. This file would not
fit. The file contains less than 100k characters. So I asked around the
office and was told that actually the variable length string with 2bill
char limit referenced here is for VB only, and that VBA has a hard limit of
64K chars.

The actual error is:
Run Time Error 14: (out of string space)

Can anyone confirm this, or have any thoughts on the subject?

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



----------------------------------------------------
Is email taking over your day?  Manage your time with eMailBoss.  
Try it free!  http://www.eMailBoss.com

------=_NextPart_000_0028_01C2DD7E.0B894B00
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
	filename="winmail.dat"

eJ8+IiIPAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANMHAgAaAAoAAQAAAAMABAEB
A5AGABgJAAAkAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADAC4AAAAAAAMANgAA
AAAAHgBwAAEAAAA4AAAAW0FjY2Vzc0RdIHZhcmlhYmxlIHN0cmluZyBsZW5ndGggdnMgZml4ZWQg
c3RyaW5nIGxlbmd0aAACAXEAAQAAABYAAAABwt2n9Ajl+zp2U3VFOKm5CB+NrzWFAAACAR0MAQAA
ACAAAABTTVRQOkpDT0xCWUBDT0xCWUNPTlNVTFRJTkcuQ09NAAsAAQ4AAAAAQAAGDgCekt+n3cIB
AgEKDgEAAAAYAAAAAAAAAAs27Vu8qjJFkOTX4jZbWcXCgAAACwAfDgEAAAACAQkQAQAAAK0EAACp
BAAAKwgAAExaRnWp9rxnAwAKAHJjcGcxMjUWMgD4C2BuDhAwMzNPAfcCpAPjAgBjaArAc7BldDAg
BxMCgH0KgZJ2CJB3awuAZDQMYB5jAFALAwu1BdB5IHTiaAhgZ2h0BCACIBPxQGUgc3ViagWQdMou
FXAgB3BhZwuAFOCpANB0dQdAbBPgYQQQDGlnAwAPICAyIGL5AxBsaRSREOIWMQSQBCDsdG8WIBTw
dAUQDyAVkLQgQwOReQhgFPBhE+BhA+BhcCBmAxAU4G/GdgSQDvBvdz8KogqEEQqAOy0pG4pKb2iN
A6BXFZAIUGxieRuExx2zHaEAgHVsdBchG4Radx/ALh2zHsguBaBt9RuKLSHyTwUQFeEHQAXQsweQ
GhBnZSHzG4RGA2EKOhYhYyLhZC1hZGJtC4BAZGEBkRbAZask0BIgcwWwcyD4WwDAmwMQGLA6JF8l
b11PA6AEQmUQ8GxmIE9mFxuEFpAawC4Q8G5udVRtQAWgLhpgayrQbvhjLnUQsBuTBmACMCQwHlcJ
gBYAJ6AaICwgRihlYnIWYHIT4DI2xy2AAdAPUCA5Og5AEWB6TRuEVCcwJEYoLyD4UxMVFCQwW0En
Y0RdIL52CsAHMAJgFOEZEyAawN8PIBQAMxAEIBqgeAmAM6yzG4obhEhpFiAWgCwbij8j8hFgJ2Mu
YhFQFNBscHo6G4pUFNAJcBYgOpF0vncYwBJiFHEqABkEcyQw/TMmLTQlAHA1ADTDPOY71douG4RB
PF8ztWMDkQWgMwIwC3EgdRqAGLJwcD0DYHgVsRhgFpEXaCgy+F4zMRxlGAg+5z2vQL1CMUHPIDY0
S0NyMdw2KRf5PuUbhEkDoBjg30IBF7BA4B8gFJFJQZARILsY0RhgeAVAGqMEACALUf8ncDUAC4AY
uTMYAQEV8QsxGxuiHeZQFRBLQSBtef5TM8QWwAYAGRQbikvBGmD9BCB1EoAEkBSzB3BCICLh/xfC
FAAwYBPxTPEXsBYBTwWfGNEzJzWaGQQtgGJ1BUC/GDADoE2VTFg7oUIMNQbQfxWQOmBM8RqjOxAf
ADUAbvxvdBuEGqAVYFqxFOAao79BJVTxOMJUcUdRLoBrSUr/BgAYwEvQFsArsFXBA2BTIf8UshuE
O6AaoCdwPVNS4hiw/1uRVHMWNxTCVg0zpgPwNGH+MheCQ+hVASfwV/EBEDqBnyvgNPE6c1riBbFW
QhSB/xaQLYA9YlRzaBA/UBDwBCD/GOAQ8TUAZkQ7oBuESKIQ4/dJ+1yiFjQgBJADYAXABACdOZVS
UyBasAdxIEVtI3QxNCQwKAhgamIzpnP/CrAncBxrGZIAcBnQFgFBIf0aoHI4cFTCLYAFsRDwGwDv
cXIT/xUFG3tfdd9273e6/z71MqRQsCbxM+MEAFvlMpWXME8g+HPgdDmALy97T+0hAS8m4gOBL3oi
C4ACEO4vJ1UbhCzwYgCQGGAkMP985R/CfV8hDSE/hM+F34a7+0plBCBlJuJzgCugFyIa8tcZwgXA
LVE/GXBNAHAjEW+JZB8gbmFk82WKIAMQQv5vBBAZYS81LgFmcQNQCeC+IRlwgRmLiCEHEeEAj6AA
AAAeAEIQAQAAADgAAAA8T0YwMTBDQ0NBRi4zRjAwQkU4NS1PTjg1MjU2Q0Q5LjAwNEZDODUzQGNv
Lndha2UubmMudXM+AAsAAYAIIAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwAigAggBgAAAAAA
wAAAAAAAAEYAAAAAUoUAAHN5AQALAC+ACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAMYAI
IAYAAAAAAMAAAAAAAABGAAAAABCFAAAAAAAAAwAygAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAA
AAADADOACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAAMATYAIIAYAAAAAAMAAAAAAAABGAAAA
AAGFAAAAAAAAHgBsgAggBgAAAAAAwAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOS4wAAsAbYAIIAYA
AAAAAMAAAAAAAABGAAAAAAaFAAAAAAAACwCHgAggBgAAAAAAwAAAAAAAAEYAAAAAgoUAAAEAAAAC
AfgPAQAAABAAAAALNu1bvKoyRZDk1+I2W1nFAgH6DwEAAAAQAAAACzbtW7yqMkWQ5NfiNltZxQIB
+w8BAAAAmAAAAAAAAAA4obsQBeUQGqG7CAArKlbCAABQU1RQUlguRExMAAAAAAAAAABOSVRB+b+4
AQCqADfZbgAAAEQ6XERvY3VtZW50cyBhbmQgU2V0dGluZ3NcamNvbGJ5XExvY2FsIFNldHRpbmdz
XEFwcGxpY2F0aW9uIERhdGFcTWljcm9zb2Z0XE91dGxvb2tcb3V0bG9vay5wc3QAAwD+DwUAAAAD
AA00/TcAAAIBfwABAAAAOgAAADxEQ0VGSkFPRU5NTkVOTEFBT0ZHUENFRUVEQUFBLmpjb2xieUBj
b2xieWNvbnN1bHRpbmcuY29tPgAAAAMABhA4570cAwAHEGQFAAADABAQAAAAAAMAERAAAAAAHgAI
EAEAAABlAAAATVlUSE9VR0hUU09OVEhFU1VCSkVDVElNQUdJTkVBQ1RVQUxMWUFTU0lHTklORzJC
SUxMSU9OQ0hBUkFDVEVSU1RPQVNUUklOR0NBTllPVVNBWVNXQVBGSUxFT1ZFUkZMT1c/OwAAAAAy
eQ==

------=_NextPart_000_0028_01C2DD7E.0B894B00--