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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Amend Relationships Programatically

Status
Not open for further replies.
Cads

Cads

Technical User
Jan 17, 2000
40
GB
Not sure if this is easily possibly in Access 97, but I thought I'd ask.

I want to be able to switch on and off the Cascade Delete setting in a relationship. On one of my screens the user can cascade delete records and on another they cannot.

I've discovered in the VBA Help the example which enables me to delete a relationship and then recreate it but I can't see simply how to amend an attribute. Can it be done reasonably efficiently?

Ta

Steve House
shouse@icaew.co.uk
 
Status
Not open for further replies.

Similar threads

jlr123
  • Locked
  • Question
6 tables - 2 tables for autofill only in form - how to set up relationships
Replies
2
Views
179
jlr123
jlr123
brucey54
  • Locked
  • Question
Tables & Relationships
Replies
1
Views
160
MajP
MajP
missymarie1014
  • Locked
  • Question
Relationships Question 1
Replies
5
Views
232
lameid
lameid
NaoTriste
  • Locked
  • Question
Amend DB connection on a .ade file and subsequent problems
Replies
0
Views
71
NaoTriste
NaoTriste
wkiernan
  • Locked
  • Question
Many To Many Relationships in Access
Replies
3
Views
187
Remou
Remou

Part and Inventory Search

Sponsor

Back
Top