Forum Moderators: open
I have successfully installed a simple asp forum on my site in progress.
The topics and messages are stored in an access database.
I am looking for a method to receive messages exceeding the max. length of the access database text field (i.e. 255 chrs.), without having to change technology to e.g. MySQL or PHP.
I am fairly new to the internet, so I hope I will be forgiven for any ignorance that I might display.
Looking forward to your well meant reply, I remain yours sincerely
Once on my first steps as a web developer I used asp/msaccess too ;-) .. now I have moved to php/mysql. But anyway as you are doing it, once I also did program a little/simple forum for my first webpage using asp/msaccess.
Following info was taken from the msaccess help:
Microsoft Access provides two field data types (field data type: A characteristic of a field that determines what kind of data it can store. For example, a field whose data type is Text can store data consisting of either text or number characters, but a Number field can store only numerical data.) to store data with text or combinations of text and numbers: Text and Memo.Use a Text data type to store data such as names, addresses, and any numbers that do not require calculations, such as phone numbers, part numbers, or postal codes. A Text field can store up to 255 characters, but the default field size is 50 characters. The FieldSize property controls the maximum number of characters that can be entered in a Text field.
Use the Memo data type if you need to store more than 255 characters. A Memo field can store up to 65,536 characters. If you want to store formatted text or long documents, you should create an OLE Object field instead of a Memo field.
Both Text and Memo data types store only the characters entered in a field; space characters for unused positions in the field aren't stored.
You can sort or group on a Text field or a Memo field, but Access only uses the first 255 characters when you sort or group on a Memo field.
Regardssss
That is excellent news and I will redefine the relevant field accordingly.
I apologize for not having found the relevant info at the msaccess help myself and for any inconvenience that I may have caused.
I seem to detect a suggestion that I should move on to php/mysql and respond by announcing that I will do so as soon as circumstances permit.
In the mean time, I work under the assumption that whatever I learn through using asp/msaccess is not redundant when moving on to php/mysql.
Thanks again caspita and may wisdom and compassion continue to accompany you, always
