Table field length limit alternative

  • Thread starter Thread starter shm135
  • Start date Start date
S

shm135

Hi,

I need a table which will hold a user's answers to about 27 survey
questions. Multiple users will use the database to enter responses for
each question. My problem is that some questions are more than 255
characters long and it isn't practical to use such long field names to
hold the actual question in. Most of the questions require responses
that are either memos, dates, numbers and yes/no fields. What would be
the best way to design a table that can hold 27 questions and the
multiple responses for each? I'd like the possibily to easily make
changes to the questions, add more questions later.

Any suggestion would be much appreciated
 
shm135,

Have a look at...

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi,

I need a table which will hold a user's answers to about 27 survey
questions. Multiple users will use the database to enter responses for
each question. My problem is that some questions are more than 255
characters long and it isn't practical to use such long field names to
hold the actual question in. Most of the questions require responses
that are either memos, dates, numbers and yes/no fields. What would be
the best way to design a table that can hold 27 questions and the
multiple responses for each? I'd like the possibily to easily make
changes to the questions, add more questions later.

Any suggestion would be much appreciated
 
It's a good thing this wasn't a question about time! You might have said the
change to Daylight Savings Time changes time by 60 seconds.
 
Steve,

Please grow up... either assist or move along.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

It's a good thing this wasn't a question about time! You might have said the
change to Daylight Savings Time changes time by 60 seconds.
 
Gina, it is futile having a battle of wits with an unarmed opponent. Leave
stevie to his delusions.

John...
 
As far as the 255 character limitation, you might consider upgrading to
something like SQL Server or Oracle. They can handle thousands of characters
in a field.
 
shm135,

Have a look at...

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm


Hi,

I need a table which will hold a user's answers to about 27 survey
questions. Multiple users will use the database to enter responses for
each question. My problem is that some questions are more than 255
characters long and it isn't practical to use such long field names to
hold the actual question in. Most of the questions require responses
that are either memos, dates, numbers and yes/no fields. What would be
the best way to design a table that can hold 27 questions and the
multiple responses for each? I'd like the possibily to easily make
changes to the questions, add more questions later.

Any suggestion would be much appreciated
Click to expand...

Thank you Gina, That really helped.
 
shm135,

You're welcome, glad it helped!

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

shm135,

Have a look at...

http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm


Hi,

I need a table which will hold a user's answers to about 27 survey
questions. Multiple users will use the database to enter responses for
each question. My problem is that some questions are more than 255
characters long and it isn't practical to use such long field names to
hold the actual question in. Most of the questions require responses
that are either memos, dates, numbers and yes/no fields. What would be
the best way to design a table that can hold 27 questions and the
multiple responses for each? I'd like the possibily to easily make
changes to the questions, add more questions later.

Any suggestion would be much appreciated
Click to expand...

Thank you Gina, That really helped.
 
Back
Top