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!

Change Referential Integrity in VB

Status
Not open for further replies.
nickperez22

nickperez22

Technical User
Jun 13, 2001
62
US
I have a distributed application and have recently made a change to the db that requires me to take out the referential integrity that exist between 2 tables. Of course I can do this by opening the db and taking out the referential integrity but I have 18 applications out there, and it would require doing each one manually either by physically visiting the site or hooking up remotely.

A better option would be if I could somehow code this change, but is this is possible?

 
Sort by date Sort by votes
Nick,
Check out the Relation Object, you can manipulate this via DA0.
--Jim
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

1DMF
  • Locked
  • Question
Audit trail - referential integrity on deleted records 2
Replies
8
Views
165
johnherman
johnherman
MrStohler
  • Locked
  • Question
Beginner Q: How to separate data from Excel into related tables and maintain relationship? 1
Replies
5
Views
374
SkipVought
S
TrekBiker
  • Locked
  • Question
Choose Backend using VBA 1
Replies
4
Views
446
Andrzejek
Andrzejek
cortextual
  • Locked
  • Question
Referential integrity issue: no unique index found for the referenced field of the primary table
Replies
2
Views
347
MajP
MajP
Lidias13
  • Locked
  • Question
Odata contains fields from multiple tables in single table with different field names - for same
Replies
1
Views
305
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top