Results 1 to 2 of 2
  1. #1
    Matthieu is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Nov 2009
    Posts
    31

    Question "Too many fields defined" error


    I modified a query of mine but since then I can't run it because it gives me a "Too many fields defined" error. I have tried selecting Repair and Compact Database to get it to work but that has not. I'm not sure what else to do. The query has a ridiculous number of fields because it basically compiles all tables into one query, and then other queries run off of that for reporting (horribly inefficient, I know, but when I set it up I know virtually nothing about Access or how to set up a database). There are currently something like 120 fields, and when I added one more, it stopped working and gave that error. I am planning on redoing the database to make it easier to use and more efficient, but don't have time right now. I'm looking for a fix that I can use until I have time to redo this monstrosity. Anything that I can do that is fairly quick? Any help would be greatly appreciated!

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Something else is going on. Access allows 255 fields in a table or a query.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 06-14-2010, 02:31 PM
  2. Fields do not show in "Form View"
    By hawzmolly in forum Forms
    Replies: 4
    Last Post: 01-09-2010, 06:27 PM
  3. Error: "User-defined type not defined"
    By mastromb in forum Programming
    Replies: 10
    Last Post: 01-08-2010, 02:57 PM
  4. Error message and How do I find the "value Field" ?
    By createdwithfire in forum Forms
    Replies: 1
    Last Post: 11-05-2009, 12:26 PM
  5. Replies: 3
    Last Post: 05-30-2009, 12:30 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums