Q: Can't Delete relationships!

[MarkD]

Using Access 2000.

I deleted relationships on my database, but
MSysRelationships still shows the relationships there.
I've compacted the database, cleared all the
relationships, etc. Can't delete from MSysRelationships
either.

I'd rather not have to import the objects to another
database. I have VB bug
http://support.microsoft.com/default.aspx?scid=kb;en-
us;304548 and because I work for a big company, I cannot
install the update and the resolution is just tedious. If
it's the only way though...

 

[david epsom dot com dot au]

1) Deleting tables from the relationship view does not
delete relationships. Show all in the view, then select
each relationship you wish to delete.

2) You can use DAO to delete relationships:

Dim rl As DAO.Relation
Dim rls As DAO.Relations

Set rls = db.Relations
For Each rl In rls
Debug.Print rl.Name
if rl.name = "fredfred" then
rls.delete rl.name
endif
Next


(david)

 

[MarkD]

Thanks David, that works.

Tried everything but actually doing that... silly me.

-Mark