MSysRelationships

  • Thread starter Thread starter Loterken
  • Start date Start date
how can i get insert permission on the MSysRelationships table ?
tia
Click to expand...

You can't, you needn't, and you shouldn't!

That's sort of like rebuilding your car's transmission... with the engine
running in traffic <g>.

I'd use VBA with the CreateRelation method to accomplish what you're trying to
do.
 
I'd use VBA with the CreateRelation method to accomplish what you're
trying to do
Click to expand...
Thanks John, i was afraid i had to do that
but if there is no other way, i'll do it
 
If you want to use SQL instead of DAO, what you
are looking for is a statement using
ALTER TABLE ... CONSTRAINT ...FOREIGN KEY...REFERENCES

Depending on what you are doing, you may have to first use
CREATE INDEX

(david)
 
Thanks david
but that is what i was trying to avoid
i was looking for an easy way out...just inserting records in
MSysRelationships
but if it cannot be done...then it cannot be done
 
It's not that it can't be done, it's just that that table
is only the report table for the relationship view window.

The actual relationships are foreign key relationships
on the other tables.

(david)
 
Back
Top