Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Relationship Limitation?

Status
Not open for further replies.

vwhite

Programmer
Oct 4, 2001
87
AU
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?
[curse]
....vwhite

"Benefit others. If you cannot benefit others then do them no harm"
- His Holiness Tenzin Gyatso, the 14th Dalai Lama
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top