Alter MSysRelationships

[Tausif]

Hi All Gurus,

I would like to append a field at MSysRelationships MS Access system Table.
Just like to know, is it possible?

Appricitate to have help comments, doc or url.

Thankx..

Tausif.

 

[david epsom dot com dot au]

Codedb.execute "Alter table MyTable add

CONSTRAINT name {PRIMARY KEY | UNIQUE | NOT NULL |
REFERENCES foreigntable [(foreignfield1, foreignfield2)];

(david)

 

[John Vinson]

Hi All Gurus,

I would like to append a field at MSysRelationships MS Access system Table.
Just like to know, is it possible?

No.

The systems tables are locked from editing - which is probably a good
thing, since they're not documented and used in altogether nonstandard
ways under the hood.

John W. Vinson[MVP]

 

[Tony Toews]

I would like to append a field at MSysRelationships MS Access system Table.
Just like to know, is it possible?

Why? What is your objective? You can update the relationships
collection using DAO.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tausif]

Dear Tony,

Actually, I have created a control for ASP. It am using ADO to read the
table structure and created the ADD, UPdate, DELETE and List interfaces
(GUI) including data validation and shows combo box for master information.
Now, I stuck in a position where I need a field at MsysRelationships to
store relationship caption. And it needs amendment.

I think, it is not possible at all. But if you have any trick. Please let me
know.
Thankx.

Tausif.

 

[John Vinson]

I think, it is not possible at all. But if you have any trick. Please let me
know.

What you could do is create your own table (perhaps give it a name
starting with USys so it will be seen as a systems table), using the
same Primary Key as MSysRelationships; use a query joining the two
tables one to one.

You can find the value of the MSysRelationships PK by searching for
the table and field names. The fieldnames in MSysRelationships may
have changed from Access version to version, so check yours.


John W. Vinson[MVP]