MS Access Error: Invalid field definition 'CON474' in definition of index or relationship ...

What is this word supposed to be?

What’s with the clanks in Endgame?

Prove the alternating sum of a decreasing sequence converging to 0 is Cauchy.

How to not starve gigantic beasts

How to get even lighting when using flash for group photos near wall?

Arriving in Atlanta after US Preclearance in Dublin. Will I go through TSA security in Atlanta to transfer to a connecting flight?

Passing args from the bash script to the function in the script

My admission is revoked after accepting the admission offer

finding a tangent line to a parabola

How can I wire a 9-position switch so that each position turns on one more LED than the one before?

Bayes factor vs P value

How to avoid introduction cliches

Retract an already submitted recommendation letter (written for an undergrad student)

A strange hotel

Why isn't everyone flabbergasted about Bran's "gift"?

What's parked in Mil Moscow helicopter plant?

What's the difference between using dependency injection with a container and using a service locator?

What do you call the part of a novel that is not dialog?

How to keep bees out of canned beverages?

Can I criticise the more senior developers around me for not writing clean code?

Check if a string is entirely made of the same substring

A faster way to compute the largest prime factor

Map material from china not allowed to leave the country

What is the ongoing value of the Kanban board to the developers as opposed to management



MS Access Error: Invalid field definition 'CON474' in definition of index or relationship



Unicorn Meta Zoo #1: Why another podcast?
Announcing the arrival of Valued Associate #679: Cesar ManaraMS Access: Force input mask characters in fieldCreating Relationship in MS AccessMS Access 2010 Expression error when using Column filter - “The expression ”|“ you entered is invalid.”Access relationship - First- and last name into ArtistMicrosoft Access Left Join Query Giving “Invalid Operation” ErrorMicrosoft Access Form - Auto Populate Form Field From Another FormMicrosoft Access 2003 - Multiple checkboxes to fill a text fieldMS Access ACCDB : Corrupted Database “Id is not an index”MS Access Conditional formatting not workingMS Access Created default value on form field, not showing





.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}







1















Looking for some help with a MS Access problem.



I am creating a bunch of linked tables between Access and our AS400 (iSeries) system. I have some OBDC DSN's set up and can access the system without issue.
A few however give me the below error (typically the more important ones):
Invalid field definition 'CON474' in definition of index or relationship
CON474 would imply it's the file name but when I check the file in Query400 it doesn't seem to be a field name or code within that file - odd!



Anyone have any previous similar issues or any suggestions to resolve.
My backup solution is creating in Excel PowerQuery which works with these files but is generally painful and clunky.



Thanks
Ben










share|improve this question







New contributor




Ben Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.



























    1















    Looking for some help with a MS Access problem.



    I am creating a bunch of linked tables between Access and our AS400 (iSeries) system. I have some OBDC DSN's set up and can access the system without issue.
    A few however give me the below error (typically the more important ones):
    Invalid field definition 'CON474' in definition of index or relationship
    CON474 would imply it's the file name but when I check the file in Query400 it doesn't seem to be a field name or code within that file - odd!



    Anyone have any previous similar issues or any suggestions to resolve.
    My backup solution is creating in Excel PowerQuery which works with these files but is generally painful and clunky.



    Thanks
    Ben










    share|improve this question







    New contributor




    Ben Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.























      1












      1








      1








      Looking for some help with a MS Access problem.



      I am creating a bunch of linked tables between Access and our AS400 (iSeries) system. I have some OBDC DSN's set up and can access the system without issue.
      A few however give me the below error (typically the more important ones):
      Invalid field definition 'CON474' in definition of index or relationship
      CON474 would imply it's the file name but when I check the file in Query400 it doesn't seem to be a field name or code within that file - odd!



      Anyone have any previous similar issues or any suggestions to resolve.
      My backup solution is creating in Excel PowerQuery which works with these files but is generally painful and clunky.



      Thanks
      Ben










      share|improve this question







      New contributor




      Ben Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.












      Looking for some help with a MS Access problem.



      I am creating a bunch of linked tables between Access and our AS400 (iSeries) system. I have some OBDC DSN's set up and can access the system without issue.
      A few however give me the below error (typically the more important ones):
      Invalid field definition 'CON474' in definition of index or relationship
      CON474 would imply it's the file name but when I check the file in Query400 it doesn't seem to be a field name or code within that file - odd!



      Anyone have any previous similar issues or any suggestions to resolve.
      My backup solution is creating in Excel PowerQuery which works with these files but is generally painful and clunky.



      Thanks
      Ben







      microsoft-access odbc db2






      share|improve this question







      New contributor




      Ben Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      Ben Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      Ben Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 17 hours ago









      Ben SmithBen Smith

      61




      61




      New contributor




      Ben Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      Ben Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      Ben Smith is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          0






          active

          oldest

          votes












          Your Answer








          StackExchange.ready(function() {
          var channelOptions = {
          tags: "".split(" "),
          id: "3"
          };
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function() {
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled) {
          StackExchange.using("snippets", function() {
          createEditor();
          });
          }
          else {
          createEditor();
          }
          });

          function createEditor() {
          StackExchange.prepareEditor({
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader: {
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          },
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          });


          }
          });






          Ben Smith is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1429104%2fms-access-error-invalid-field-definition-con474-in-definition-of-index-or-rel%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes








          Ben Smith is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          Ben Smith is a new contributor. Be nice, and check out our Code of Conduct.













          Ben Smith is a new contributor. Be nice, and check out our Code of Conduct.












          Ben Smith is a new contributor. Be nice, and check out our Code of Conduct.
















          Thanks for contributing an answer to Super User!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid



          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1429104%2fms-access-error-invalid-field-definition-con474-in-definition-of-index-or-rel%23new-answer', 'question_page');
          }
          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Couldn't open a raw socket. Error: Permission denied (13) (nmap)Is it possible to run networking commands...

          VNC viewer RFB protocol error: bad desktop size 0x0I Cannot Type the Key 'd' (lowercase) in VNC Viewer...

          Why not use the yoke to control yaw, as well as pitch and roll? Announcing the arrival of...