A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

exceed limit of 255 fields



 
 
Thread Tools Display Modes
  #1  
Old October 18th, 2005, 04:12 PM
blackcat
external usenet poster
 
Posts: n/a
Default exceed limit of 255 fields

i have created a database which has huge table, i need to add more fields to
this table (really does need to be in the same table as i have some very
complex calculations going on too!) only i now get the message 'exceeds limit
of 255 fields' is there any way i can over wright this?
  #2  
Old October 18th, 2005, 04:40 PM
Ken Snell [MVP]
external usenet poster
 
Posts: n/a
Default exceed limit of 255 fields

ACCESS limits you to 255 fields in any one table. I've never exceeded 35
fields in a table, so if you're trying to get more fields than 255 then you
may be trying to turn your table into a spreadsheet.

Most likely, you need to normalize your table structure... use records to
save different variations of a single entity, not fields.

--

Ken Snell
MS ACCESS MVP

"blackcat" wrote in message
news
i have created a database which has huge table, i need to add more fields
to
this table (really does need to be in the same table as i have some very
complex calculations going on too!) only i now get the message 'exceeds
limit
of 255 fields' is there any way i can over wright this?


  #3  
Old October 18th, 2005, 06:00 PM
Rick B
external usenet poster
 
Posts: n/a
Default exceed limit of 255 fields

Ummm- you should redesign your table. At the most, you should have 20 or 30
fields in a table.

You may want to explain your structure so we can recommend how you can
improve it. Sounds like you are using Access as a Spreadsheet, not as a
relational database. Doing so will cause you many many headaches.

--
Rick B



"blackcat" wrote in message
news
i have created a database which has huge table, i need to add more fields
to
this table (really does need to be in the same table as i have some very
complex calculations going on too!) only i now get the message 'exceeds
limit
of 255 fields' is there any way i can over wright this?


  #4  
Old October 18th, 2005, 06:15 PM
Tim Ferguson
external usenet poster
 
Posts: n/a
Default exceed limit of 255 fields

"=?Utf-8?B?YmxhY2tjYXQ=?=" wrote in
news
(really does need to be in the same table as i have some very
complex calculations going on too!)


Sounds like a job for Excel to me too...


Tim F

  #5  
Old October 18th, 2005, 06:34 PM
Rick B
external usenet poster
 
Posts: n/a
Default exceed limit of 255 fields

Just one more thought. You say it really needs to be in the same table due
to complex calculations. Not sure what that has to do with it. You can
pull data from many tables into a query, report, and form to perform
calculations.

Hopefully you are not storing any of these calculated values in the table.
With few exceptions, that is not recommended. Calculations should be
performed in the queries, reports, or forms. Storing them in the table can
lead to problems if you need to change one of the numbers upon which your
calculation is based.

--
Rick B



"Rick B" Anonymous wrote in message
...
Ummm- you should redesign your table. At the most, you should have 20 or
30 fields in a table.

You may want to explain your structure so we can recommend how you can
improve it. Sounds like you are using Access as a Spreadsheet, not as a
relational database. Doing so will cause you many many headaches.

--
Rick B



"blackcat" wrote in message
news
i have created a database which has huge table, i need to add more fields
to
this table (really does need to be in the same table as i have some very
complex calculations going on too!) only i now get the message 'exceeds
limit
of 255 fields' is there any way i can over wright this?





  #6  
Old October 19th, 2005, 12:27 AM
Douglas J. Steele
external usenet poster
 
Posts: n/a
Default exceed limit of 255 fields

"Tim Ferguson" wrote in message
...
"=?Utf-8?B?YmxhY2tjYXQ=?=" wrote in
news
(really does need to be in the same table as i have some very
complex calculations going on too!)


Sounds like a job for Excel to me too...


Except Excel can only go up to column IV, or 256 columns...

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)




  #7  
Old October 19th, 2005, 12:03 PM
blackcat
external usenet poster
 
Posts: n/a
Default exceed limit of 255 fields

thanks for your response, so if i create a new table, how can i pull this
into the existing form that i have, ie how do i use two tables on one form or
report. my calculations are stored in a macro, hense the reason for needed
to have all fields on one form

"Rick B" wrote:

Just one more thought. You say it really needs to be in the same table due
to complex calculations. Not sure what that has to do with it. You can
pull data from many tables into a query, report, and form to perform
calculations.

Hopefully you are not storing any of these calculated values in the table.
With few exceptions, that is not recommended. Calculations should be
performed in the queries, reports, or forms. Storing them in the table can
lead to problems if you need to change one of the numbers upon which your
calculation is based.

--
Rick B



"Rick B" Anonymous wrote in message
...
Ummm- you should redesign your table. At the most, you should have 20 or
30 fields in a table.

You may want to explain your structure so we can recommend how you can
improve it. Sounds like you are using Access as a Spreadsheet, not as a
relational database. Doing so will cause you many many headaches.

--
Rick B



"blackcat" wrote in message
news
i have created a database which has huge table, i need to add more fields
to
this table (really does need to be in the same table as i have some very
complex calculations going on too!) only i now get the message 'exceeds
limit
of 255 fields' is there any way i can over wright this?






  #8  
Old October 19th, 2005, 05:08 PM
Tim Ferguson
external usenet poster
 
Posts: n/a
Default exceed limit of 255 fields

"Douglas J. Steele" wrote in
:


Sounds like a job for Excel to me too...


Except Excel can only go up to column IV, or 256 columns...



Hmmm... I think we are all agreed that some major design thinking is
required. Doing calculations in SQL is so horrid that my instinct is always
to take the whole lot off to something intended for the task, like SPSS or
Excel etc etc. Even if the storage method is still Jet, of course.

All the best


Tim F

  #9  
Old October 19th, 2005, 06:12 PM
Rick B
external usenet poster
 
Posts: n/a
Default exceed limit of 255 fields

You would base your form on a QUERY which can contain several related
tables. Just breaking this into two pieces is not the answer though.
Sounds like your structure is badly flawed. Sounds like you should have
several one-to-many relationships.

What is in this table? What is the structure of your data? If you have
things like...

Salary2004 Salary2005 Slaary2006

or

Hobby1 Hobby2 Hobby3

etc,

Then you want to stop, step back, and rethink your design. Those examples
point to cases where a one-to-many relationship should be used. This will
involve addind a new table with two fields. One for the person's
identification number, and one for their Hobby. Or, in the Salray example,
three fields. One for the ID, one for the amount, and one for the date.
These new tables would be related to the original table where the person's
information is stored.

Give us some detials about your data and we can give you some ideas.

--
Rick B



"blackcat" wrote in message
...
thanks for your response, so if i create a new table, how can i pull this
into the existing form that i have, ie how do i use two tables on one form
or
report. my calculations are stored in a macro, hense the reason for
needed
to have all fields on one form

"Rick B" wrote:

Just one more thought. You say it really needs to be in the same table
due
to complex calculations. Not sure what that has to do with it. You can
pull data from many tables into a query, report, and form to perform
calculations.

Hopefully you are not storing any of these calculated values in the
table.
With few exceptions, that is not recommended. Calculations should be
performed in the queries, reports, or forms. Storing them in the table
can
lead to problems if you need to change one of the numbers upon which your
calculation is based.

--
Rick B



"Rick B" Anonymous wrote in message
...
Ummm- you should redesign your table. At the most, you should have 20
or
30 fields in a table.

You may want to explain your structure so we can recommend how you can
improve it. Sounds like you are using Access as a Spreadsheet, not as
a
relational database. Doing so will cause you many many headaches.

--
Rick B



"blackcat" wrote in message
news i have created a database which has huge table, i need to add more
fields
to
this table (really does need to be in the same table as i have some
very
complex calculations going on too!) only i now get the message
'exceeds
limit
of 255 fields' is there any way i can over wright this?







  #10  
Old October 20th, 2005, 09:31 AM
blackcat
external usenet poster
 
Posts: n/a
Default exceed limit of 255 fields

i have title information which holds no cass,cds, roylty information,
production info, etc on table a, other tables which store costs etc, i then
us a dlookup to pull this info into table a, i then have a macro which stores
all the calculations and belive me there are loads, this database started out
being fairly simple with just a few calculations and has grown so much! i
need to do it in access as not excel as we need to report on the titles and
recall them etc. thanks for your help and advice on this

"Rick B" wrote:

You would base your form on a QUERY which can contain several related
tables. Just breaking this into two pieces is not the answer though.
Sounds like your structure is badly flawed. Sounds like you should have
several one-to-many relationships.

What is in this table? What is the structure of your data? If you have
things like...

Salary2004 Salary2005 Slaary2006

or

Hobby1 Hobby2 Hobby3

etc,

Then you want to stop, step back, and rethink your design. Those examples
point to cases where a one-to-many relationship should be used. This will
involve addind a new table with two fields. One for the person's
identification number, and one for their Hobby. Or, in the Salray example,
three fields. One for the ID, one for the amount, and one for the date.
These new tables would be related to the original table where the person's
information is stored.

Give us some detials about your data and we can give you some ideas.

--
Rick B



"blackcat" wrote in message
...
thanks for your response, so if i create a new table, how can i pull this
into the existing form that i have, ie how do i use two tables on one form
or
report. my calculations are stored in a macro, hense the reason for
needed
to have all fields on one form

"Rick B" wrote:

Just one more thought. You say it really needs to be in the same table
due
to complex calculations. Not sure what that has to do with it. You can
pull data from many tables into a query, report, and form to perform
calculations.

Hopefully you are not storing any of these calculated values in the
table.
With few exceptions, that is not recommended. Calculations should be
performed in the queries, reports, or forms. Storing them in the table
can
lead to problems if you need to change one of the numbers upon which your
calculation is based.

--
Rick B



"Rick B" Anonymous wrote in message
...
Ummm- you should redesign your table. At the most, you should have 20
or
30 fields in a table.

You may want to explain your structure so we can recommend how you can
improve it. Sounds like you are using Access as a Spreadsheet, not as
a
relational database. Doing so will cause you many many headaches.

--
Rick B



"blackcat" wrote in message
news i have created a database which has huge table, i need to add more
fields
to
this table (really does need to be in the same table as i have some
very
complex calculations going on too!) only i now get the message
'exceeds
limit
of 255 fields' is there any way i can over wright this?








 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate Merge Fields via VB.NET ben Mailmerge 5 June 21st, 2005 05:43 PM
Outlook contacts doesn't allow all fields from Excel? gnmcewen Contacts 0 January 9th, 2005 05:21 AM
Additional fields for form based parameter query/null fields geeksdoitbetter Running & Setting Up Queries 2 January 7th, 2005 11:05 PM
Populate fields in Form Header based on header fields in startup f Pat Dools Using Forms 0 January 7th, 2005 04:19 PM
Automatic filling of fields in table two from table one Jim Kelly Database Design 1 September 27th, 2004 10:16 PM


All times are GMT +1. The time now is 10:08 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.