|
| 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
November 5th, 2004, 08:45 PM
|
|||
|
|||
Error 3190 - Too Many Fields Defined
MS Access 2002 SP3
Building a fairly complex financial forecast model. Several nested queries. Well into the nested query ran into Error 3190. Anyone know a workaround other than writing the data out to a temporary file? (temporary files are error prone since it would require manual intervention to run the macro). Does a newer release accomodate for this? Would hate to not be able to use MS Access... Thanks! 
|
|
#2
November 5th, 2004, 10:49 PM
|
|||
|
|||
|
255 fields is still the limit, but the general consensus is that's usually
at least 200 more than required. You'll have to provide some more details about your design so that others can comment and perhaps suggest an approach that'll work. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Dan" wrote in message ... MS Access 2002 SP3 Building a fairly complex financial forecast model. Several nested queries. Well into the nested query ran into Error 3190. Anyone know a workaround other than writing the data out to a temporary file? (temporary files are error prone since it would require manual intervention to run the macro). Does a newer release accomodate for this? Would hate to not be able to use MS Access... Thanks!
|
|
#3
November 6th, 2004, 07:39 AM
|
|||
|
|||
|
you can automate the creation of temporary files! i do not see why it hads
to be by a macro !!! I hate macros! Evan Camilleri "Dan" wrote in message ... MS Access 2002 SP3 Building a fairly complex financial forecast model. Several nested queries. Well into the nested query ran into Error 3190. Anyone know a workaround other than writing the data out to a temporary file? (temporary files are error prone since it would require manual intervention to run the macro). Does a newer release accomodate for this? Would hate to not be able to use MS Access... Thanks!
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| too many fields defined | Chris S | Database Design | 3 | April 25th, 2005 03:14 AM |
| Problem with changing defined ranges... | BeSmart | Worksheet Functions | 6 | September 28th, 2004 08:23 AM |
| Automatic filling of fields in table two from table one | Jim Kelly | Database Design | 1 | September 27th, 2004 10:16 PM |
| Too Many Fields Defined | Tristanne | Database Design | 1 | September 15th, 2004 06:02 PM |
| disappearing user defined fields | Terri | Contacts | 1 | June 1st, 2004 11:44 PM |
Linear Mode
