Table field length limit alternative

[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

 

[Gina Whipp]

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

 

[Steve]

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 Whipp]

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.

 

[John... Visio MVP]

Gina, it is futile having a battle of wits with an unarmed opponent. Leave
stevie to his delusions.

John...

 

[Gina Whipp]

Thank you for the reminder! I tend to forget that...

--
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

Gina, it is futile having a battle of wits with an unarmed opponent. Leave
stevie to his delusions.

John...

 

[Jerry Whittle]

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]

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

Thank you Gina, That really helped.

 

[Gina Whipp]

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

Thank you Gina, That really helped.