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;
}
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
New contributor
add a comment |
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
New contributor
add a comment |
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
New contributor
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
microsoft-access odbc db2
New contributor
New contributor
New contributor
asked 17 hours ago
Ben SmithBen Smith
61
61
New contributor
New contributor
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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.
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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