Relationship missing

What can cause a relationship to be missing.

I had a relationship setup between two tables. It had been working fine.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11795-relationship-missing.html
However today I had users complaining about dtatbase issue. When I looked at
the relationships I found that the link was missing.

What can cause this issue?

Matt

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11795

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Hi Matt

A relationship may be deleted either through the UI (the relationships
window) or through code.

I have never known a relationship to just "disappear", although it's
conceivable that it could happen if a database became corrupted. Have you
tried compacting and repairing the database?
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

"mattc66 via AccessMonster.com" wrote in message
news:6212401e18c53@uwe...
> What can cause a relationship to be missing.
>
> I had a relationship setup between two tables. It had been working fine.
> However today I had users complaining about dtatbase issue. When I looked
> at
> the relationships I found that the link was missing.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11795
>
> What can cause this issue?
>
> Matt
>
> --
> Matt Campbell
> mattc (at) saunatec [dot] com
>
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...ccess/200606/1
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11795

I would reccomend using SQL Server instead of MDB.

a) it doesnt just randomly get corrupted
b) it is easy to script RI so that you can enforce it on a scheduled
basis

SQL just has much easier version control than MDB.

these days; you can put DDL triggers to table; so that if anyone
changes ANYTHING in a table you can rollback changes; etc

-Aaron



Graham Mandeno wrote:
> Hi Matt
>
> A relationship may be deleted either through the UI (the relationships
> window) or through code.
>
> I have never known a relationship to just "disappear", although it's
> conceivable that it could happen if a database became corrupted. Have you
> tried compacting and repairing the database?
> --
> Good Luck!
>
> Graham Mandeno [Access MVP]
> Auckland, New Zealand
>
> "mattc66 via AccessMonster.com" wrote in message
> news:6212401e18c53@uwe...
> > What can cause a relationship to be missing.
> >
> > I had a relationship setup between two tables. It had been working fine.
> > However today I had users complaining about dtatbase issue. When I looked
> > at
> > the relationships I found that the link was missing.
> >
> > What can cause this issue?
> >
> > Matt
> >
> > --
> > Matt Campbell
> > mattc (at) saunatec [dot] com
> >
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11795
> > Message posted via AccessMonster.com
> > http://www.accessmonster.com/Uwe/For...ccess/200606/1
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11795

I would like to move to SQL - However I have legacy data that I bring into
Access via ASC (ascii) and I have not figured out how to do the same with SQL.
New to SQL..

dbahooker@hotmail.com wrote:
>I would reccomend using SQL Server instead of MDB.
>
>a) it doesnt just randomly get corrupted
>b) it is easy to script RI so that you can enforce it on a scheduled
>basis
>
>SQL just has much easier version control than MDB.
>
>these days; you can put DDL triggers to table; so that if anyone
>changes ANYTHING in a table you can rollback changes; etc
>
>-Aaron
>
>> Hi Matt
>>
>[quoted text clipped - 24 lines]
>> > Matt Campbell
>> > mattc (at) saunatec [dot] com

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200606/1
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11795
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11795