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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |