ACCESS 2016, too many fields defined error

Anonymous
2015-12-29T01:14:32+00:00

My query give me an error TO MANY FIELDS DEFINED. When i count the fields i have only used 226.

What is causing this?

Thanks for any help

ed

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2017-12-22T00:15:56+00:00

Not without using subreports because once tied together they will be over 255.

Side note:  Sounds like the person who advised you is using far less of the data in the tables than you, is that so?

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2017-12-05T00:47:27+00:00

Not into word into the window on the web page in the link I posted.

Hmm, yep you need to bring it into a clean one again.  Note, what you downloaded was probably flat file format which means that is the way they display it not store it.

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2017-12-04T21:51:05+00:00

Passing on secret tip....

To format queries for easier reading, go to...

https://sqlformat.org/

Just copy in the SQL and click the Format SQL button.  (Really wish that was built into Access!)

No problem glad to help.  And hopefully, this post never disappears!

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2016-01-07T22:57:03+00:00

No problem... will get a message even if you reply 10 years from now! :)

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2015-12-29T01:41:09+00:00

Hmm, could be one of those deceptive messages because there is also a 1.024 character limit and spaces count!

That said, a query with that many fields is the *real* concern.  It sounds like an UN-normalized structure.  Why so many fields in the query?

Was this answer helpful?

1 person found this answer helpful.
0 comments

64 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2015-12-31T00:19:36+00:00

    Gina

    If im asking you to many questions or taking up to much of your time, please let me know and will stop bothering you. I dont want you to waste your time with someone who isnt to access savvy. 

    Once i make this new data base, I wont make one for a couple of years. Even though I take good notes, they never seem to work one year later.

    Back in I think 2012 I had this problem and microsoft  fixed it by making me a new data base. Support must of been free then

    When I had this problem in 2014, I was going to pay microsoft If they would fix my problem. While trying to fix my problem of to many fields defined, the tech found a problem with their program. I believe he said compact and repair should reset the access counters back to zero. Here is what he done to fix my problem. [Im just telling you this for your own knowledge]

    --Go into the queries data base-dont open it.

    --database tools

    --analyse performance

    --select query

    --ok

    --select one table at a time and optimize it .

    --Bingo the counter was reset.

    Microsoft has done this twice for me. They said to just keep calling them until they fixed the problem.

    --Now they no longer return my calls.

    I know creating a database will restore my counters. For you this is easy, but for me it isnt. 

    Here is what i have.

    --TABLES--My program gets its data from 9 tables.

    --The only way I can view these tables is from the template, I download it from the company. I download the table data into the companies program HTR. I have on my computer. Once in there I then export them over to my blank template. My template has keys that let me either export the table date to access or delete it from access.

    Once have a new template I import the following into my template.--Every time the company adds new fields we get new template.

    MY PROGRAM CONSISTS OF THE FOLLOWNG.

    --QUERIES--9 of them

    HELPER--Im sure why i have it but microsoft set it up

    LINK--I think this links two of these queries into main report

    7 other queries

    REPORT

    --HELPER--I think this is used with LUCK

    LONG

    L3A

    L3AA

    LUCK--In LUCK L3A AND L3AA are combined to make my luck program.

    I hope i explained myself. If you decide im to confusing to help, please tell me and I will thank you for all you help. You sure have giving me a lot. If you decide to continue, I will do my best.

    I thought playing the ponies was tough, Ill take it over access anytime.

    Thanks for you help and time.

    ed

    Was this answer helpful?

    0 comments