Remove relationship programatically

[Charlix]

Hi,
I hope I'm posting this on the correct forum.

I get the following error message when I try to remove a one to many relationship in my database programatically:

*******
object required '[string: "C:\Caps1\CapsDb1.mdb"]'
*******

This is the code I am using on my asp page"

*******************
Set db = "caps1\capsDB1.mdb"

set rel = db.CreateRelation("321", "Multi Table", "Records Table")
rel.attributes = dbRelationDontEnforce
Set fld = rel.CreateField("MID")
fld.ForeignName = "MID"
rel.Fields.Append fld
db.Relations.Append rel

db.Relations.Update
*********************

What am I doing wrong?

Thanks,

Charlix

 

[PHV]

What am I doing wrong?
You are doing that:
set rel = "caps1\capsDB1.mdb".CreateRelation("321", "Multi Table", "Records Table")

You have to instantiate a Database object

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Charlix]

Thanks,
Charlix