get access runtime error -1517

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I added a field to an Access 2003 database. The field is linked to another
table via a query "SELECT PlanAssetType.PlanAssetTypeDescription,
PlanAssetType.PlanAssetTypeID
FROM PlanAssetType
ORDER BY PlanAssetType.PlanAssetTypeDescription;"
The field is bound to column 2 and it is shown in a combo box.
(This is similar to another field on the table which is error-free). The
problem is, when browsing the table thru table linking, the linked value does
not show. If one clicks on the field, I get this error msg "reserved error
(-1517); there is no message for this error". And one has a hard time getting
rid of the error. Occasionally, users get the same error when trying to
modify the field (via form) and have to cancel the task to get out of it.
Additionally, sometimes the field has problems, sometimes not.

Any help would be appreciated. I know the desc is spotty, but I'm hoping
someone may have encountered it before and knows what I'm talking about.
Thank you.
 
Here is what that error means:

JET_errBadColumnId -1517 Column Id Incorrect

Now, how that applies to your situation. Possibly it is a data error in the
PlanAssetType table, e.g., a NULL value in the PlanAssetTypeID column.
 
I saw 4 fields with nulls and was thinking that might be the problem. I'll
see if it works.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 1517 9
"Reserved Error (-1517) - there is no messsage for this error" mes 1
#ERROR 4
error message 1
Reserved Error (-1517) 1
error -1517 1
Reserved Error (-1517)" 2
Error Message when Opening Database 2

Back
Top