Click to See Complete Forum and Search --> : online job description catalogue


blodefood
09-29-2003, 02:42 PM
I am trying to create an online job description catalogue for my company's internal website that will allow the HR manager to enter the info in an *easy* to use web page. The data should be committed to some sort of storage and be retrievable (but not alterable) by the employees.

There are the general headings of: Job Description Name, General Duties, Primary Duties some with sub headings.

I was looking at using an Access database, but the fields are limited to 255 characters. Some paragraphs are longer than that.

Another problem is that under the Primary Duties, there may or may not be sub headings and the number of points under each heading vary greatly from one description to another.

I want to use ASP pages for this project and the descriptions are currently Word documents.

Any ideas?

:confused:

PeOfEo
09-29-2003, 04:19 PM
You can fit more then 255 into an access data base, Just change the fileds from text to memo, it will increase the character size to 65,000 some odd number, basically its a whole lot of text per feild, several meg. Just use varchar 65,000 in your sql statements. Look at my forum right now it is controlled by two access data bases (I am in the process of switching just about all of my data bases to sql server though) As you can see that is a lot more then 255 characters in many of the posts.