MS Access 2002 - Text Field Size Limit

Hi all, I know this question is not directly related to the NT operating systems, but i hope it is ok to ask it here. This is just such a knowledgeable support group, I figured I'd get an snwer here. Anyway, Access databases limit the size of...




Topic Options
#129906 - 08/09/03 09:14 PM MS Access 2002 - Text Field Size Limit
PinkPanther Offline
member

Registered: 03/17/00
Posts: 102
Hi all, I know this question is not directly related to the NT operating systems, but i hope it is ok to ask it here. This is just such a knowledgeable support group, I figured I'd get an snwer here.

Anyway, Access databases limit the size of text field to 255 charcaters. I need to know if there is a way around this limit, or if there is not, what is normally used for databases that require text field of much larger size.

I.E. what if I want to keep user comments on our website into a database, Access' 255 limit would not be enough.

We use the .Net technology for our site, so I would prefer to stay away from php/mysql combinations (I don't even know if mysql has the same limit or not)

Anyway, advice would be greatly appreciated.

Many thanks

Top
Advertisement
#129907 - 08/09/03 09:29 PM Re: MS Access 2002 - Text Field Size Limit
jimf43 Offline
enthusiast

Registered: 10/13/01
Posts: 397
Use a Memo field. The length is pretty much unlimited. Hit help and search for Memo field for details and gotchas ;-).

Top
#129908 - 08/09/03 09:41 PM Re: MS Access 2002 - Text Field Size Limit
PinkPanther Offline
member

Registered: 03/17/00
Posts: 102
thank you so much!

Top
#130064 - 08/14/03 06:41 AM Re: MS Access 2002 - Text Field Size Limit
jimbo Offline
journeyman

Registered: 05/05/03
Posts: 75
Just remember that a memo field is not indexable (or at least it wasn't in Access 97).

Top
#134734 - 12/29/03 09:18 PM Re: MS Access 2002 - Text Field Size Limit
duhmez Offline
addict

Registered: 04/27/02
Posts: 583
Loc: Canada, West siiiiiiiiiide!
And being unindexable it will most likely be useless for your purposes!
M$ wants you to buy SQl server!

Top


Forums
Windows Support Forums
Everything New Technology
Legacy OS
Hardware
Software
Games
Networking
Customization & Tweaking
Security

Linux Support Forums
Everything Linux
Linux Hardware
Linux Software
Linux Games
Linux Networking
Linux Customization & Tweaking
Linux Security

Apple Support Forums
Everything Apple
Recent Topics
Ninja coming to Conquer Online
by Meditator
2 seconds ago
StarCraft new patch problem.
by Roland Bawd
11/30/08 08:02 AM
One of the USB devices attached to this computer h
by draa
11/28/08 02:13 AM
Lan won't work -- Windows Vista Premium
by DanielS
11/27/08 11:14 PM
Please Help!
by ashwee
11/27/08 02:17 AM
Who's Online
1 Registered (Meditator), 169 Guests and 9 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
89474 Members
24 Forums
43069 Topics
172854 Posts

Max Online: 1079 @ 03/12/08 01:36 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22