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!

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

Tables with foreign keys accessed in VB

Status
Not open for further replies.
javabeanx

javabeanx

Programmer
Apr 29, 2002
10
IN
My table flat has a foreign key fid referenced hid of house
When establishing connectivity and I set my
set rs =db.OpenRecordset("select * from house")
rs.AddNew -->it says not possible read only mode
It happens to all tables that contain foreign key references
Any suggestions so that I can do both read -write??
 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
597
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
640
SkipVought
S
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
725
Andrzejek
Andrzejek
TheLazyPig
  • Locked
  • Question
Change format name with comma 1
Replies
3
Views
159
TheLazyPig
TheLazyPig
gooseriver
  • Locked
  • Question
UPDATE statement - with two tables
Replies
1
Views
113
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top