1,105,592 Community Members

edite MS Access via code

Member Avatar
kosay
Newbie Poster
11 posts since Jul 2011
Reputation Points: -2 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

hi
I have MS Access Data Base with tow tables table 1 has relashiship with Table 2
when I try edite tabe 1 error message shown tell me I can't edit table 1
do you have examble for this ?

Member Avatar
adam_k
Veteran Poster
1,056 posts since Jun 2011
Reputation Points: 239 [?]
Q&As Helped to Solve: 212 [?]
Skill Endorsements: 17 [?]
 
0
 

The exact error would really help.

Member Avatar
kosay
Newbie Poster
11 posts since Jul 2011
Reputation Points: -2 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

message is :
{"You cannot add or change a record because a related record is required in table 'Table1'."}

Member Avatar
M.Waqas Aslam
Practically a Posting Shark
837 posts since Aug 2011
Reputation Points: 67 [?]
Q&As Helped to Solve: 137 [?]
Skill Endorsements: 4 [?]
Featured
 
0
 

yes this error is only occurs when you want to edit foreign key , for example , if there is two table having fields . Stuid , name and table 2 has fields id , stuid ,in this situation if you want to edit value of Stuid in table then it is necessary that table1 has same value .in it . hope this will help you.

Regards

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article