Hello all,
Can anybody help me with this problem.
Is there a limit to the number of characters that can exist in an Access relationship? I have found much info about Access's limitations in other respects but not this one.
I have an Access 2000 database and tried to create a relationship between two fields
lkp_Assessment_Questions_tbl!AssessmentQuestionId
and
Paperbark_Assessment_LandSituation_tbl!AssessmentQuestionId
and I get the error message
"lkp_Assessment_Questions_tblPaperbark_Assessment_LandSituation_tbl is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long"
Am I missing something - or is it just too long?
....vwhite
"Benefit others. If you cannot benefit others then do them no harm"
- His Holiness Tenzin Gyatso, the 14th Dalai Lama
Can anybody help me with this problem.
Is there a limit to the number of characters that can exist in an Access relationship? I have found much info about Access's limitations in other respects but not this one.
I have an Access 2000 database and tried to create a relationship between two fields
lkp_Assessment_Questions_tbl!AssessmentQuestionId
and
Paperbark_Assessment_LandSituation_tbl!AssessmentQuestionId
and I get the error message
"lkp_Assessment_Questions_tblPaperbark_Assessment_LandSituation_tbl is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long"
Am I missing something - or is it just too long?
....vwhite
"Benefit others. If you cannot benefit others then do them no harm"
- His Holiness Tenzin Gyatso, the 14th Dalai Lama