System Relationships Magically Appear

[smedvid]

I checked my relationships and saw a relationship between
msysaccessstorage and msysaccessstorage1. I run a tight ship and document everything. I did not add this relationship.

The database (MS Access 2002 SP3) seems to be working fine.

How and why did this relationship get established?

Can I remove the relationsip without harning the database environment?

tia,

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[Shirley]

Yes you can delete msysaccessstorage1, because it is a clone or ghost of the original table. This show up if you set up a relationship prior to setting going to the relationship layout and setting the relationship yourself. Or if you add the same table again in the relationship layout. Just make sure once you delete msysaccessstorage1, that you establish the relationship with msysaccessstorage.

 

[smedvid]

Thanks...

Steve Medvid
"IT Consultant & Web Master"

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...