MSysRelationships

how can i get insert permission on the MSysRelationships table ?
tia

On Wed, 19 May 2010 00:32:14 +0200, "Loterken" wrote:

how can i get insert permission on the MSysRelationships table ?
tia


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.
--

John W. Vinson [MVP]

I'd use VBA with the CreateRelation method to accomplish what you're
trying to do
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)


"Loterken" wrote in message
...
how can i get insert permission on the MSysRelationships table ?
tia

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)

"Loterken" wrote in message
...
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