text limit in access

[pmsays]

Hi everbody,
i have developed a page in ASP for feedback from user with back-end as MS-ACCESS. But Access limits the length of text to 255 characters. Can somebody tell me someother way?

[Anglo Saxon]

Originally posted by pmsays
Can somebody tell me someother way?

Don't use Access?

Seriously though, if you must use it then I believe an Access Memo field can store up to 64k characters.

--
Anglo Saxon

[pmsays]

Thanks Anglo for telling me the way.
Actually, I am designing a feedback form in ASP. Obvoiusly, the text entered as feedback may cross 255 character limit easily.

Can you tell me any other best way to store user feedback?

[veryjonny]

Use the memo Data type for the field.

[pmsays]

Well veryjonny
What I actually want to know is- How sites having Feedback form store the the user feedback? (How professionals do this?)

Do they use Files or Memo field in Access if they are using MS-ACCESS.

[Anglo Saxon]

Originally posted by pmsays
(How professionals do this?)

Do they use Files or Memo field in Access if they are using MS-ACCESS.

IMO, 'Professionals' would certainly never use an Access database unless they had no other option, SQL Server or mySQL would be my choice of weapons.

Also, there is no set way for 'professionals' to do this, each project has to be taken on its merits and evaluated, i.e. Are there storage limitations on the hosting server? Are there bandwith issues with regard to how much data you are going to be feeding back? More importantly though, what information does your customer want to be fed back? You need to discuss these issues with your customer and come up with a set of requirements which are suitable for you both.

--
Anglo Saxon