The Case of the Disappearing Relationships

[Squirrel]

Hi everyone,

I have an Access 2002 database, split into frontend and backend, both files
on one PC for some initial test data entry. Data entry person is an
intelligent college student with no Access experience. She wouldn't go
thrashing around attempting to break things. The relationships have all
disappeared and I now have a few orphan records wandering around. Assuming
she didn't proactively delete them, does anyone know of any circumstance
whereby they could be accidentally deleted? I have no idea how this
happened and obviously don't want it to happen again.

If anyone has any ideas, let me thank you in anticipation.

Linda

[Allen Browne]

Hi Linda

There is a very good chance that this is a corruption caused by Name
AutoCorrect. To fix it:

1. Create a new (blank) database.

2. In the new database, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect

3. Import everything from the old database:
File | Get External | Import
That Import dialog has an Options button that lets you indicate whether to
import the relationships or not. Try importing them (the default). They may
get rebuilt by the import process. If they are still messed up, you can
import the tables and other objects without the relations, and rebuild the
relations by hand if necessary.

For a list of other problems caused by Name AutoCorrect, see:
http://members.iinet.net.au/~allenbrowne/bug-03.html
If you need to programmaticall y delete all of the damaged and hidden
relations in the original database so you can rebuild them, this code will
do it:
http://members.iinet.net.au/~allenbrowne/DelRel.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Squirrel" <wi*****@covad. net> wrote in message
news:b8******** *************** **@msgid.megane wsservers.com.. .

Hi everyone,

I have an Access 2002 database, split into frontend and backend, both
files
on one PC for some initial test data entry. Data entry person is an
intelligent college student with no Access experience. She wouldn't go
thrashing around attempting to break things. The relationships have all
disappeared and I now have a few orphan records wandering around.
Assuming
she didn't proactively delete them, does anyone know of any circumstance
whereby they could be accidentally deleted? I have no idea how this
happened and obviously don't want it to happen again.

If anyone has any ideas, let me thank you in anticipation.

Linda

[Squirrel]

Allen,

thx for your advice. I will follow your instructions. I hadn't understood
the Name AutoCorrect feature, just accepted the defaults... I often read
your responses to folk seeking assistance. I always learn something. Thank
you.

Linda
"Allen Browne" <Al*********@Se eSig.Invalid> wrote in message
news:41******** **************@ per-qv1-newsreader-01.iinet.net.au ...

Hi Linda

There is a very good chance that this is a corruption caused by Name
AutoCorrect. To fix it:

1. Create a new (blank) database.

2. In the new database, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect

3. Import everything from the old database:
File | Get External | Import
That Import dialog has an Options button that lets you indicate whether to
import the relationships or not. Try importing them (the default). They may get rebuilt by the import process. If they are still messed up, you can
import the tables and other objects without the relations, and rebuild the
relations by hand if necessary.

For a list of other problems caused by Name AutoCorrect, see:
http://members.iinet.net.au/~allenbrowne/bug-03.html
If you need to programmaticall y delete all of the damaged and hidden
relations in the original database so you can rebuild them, this code will
do it:
http://members.iinet.net.au/~allenbrowne/DelRel.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Squirrel" <wi*****@covad. net> wrote in message
news:b8******** *************** **@msgid.megane wsservers.com.. .

Hi everyone,

I have an Access 2002 database, split into frontend and backend, both
files
on one PC for some initial test data entry. Data entry person is an
intelligent college student with no Access experience. She wouldn't go
thrashing around attempting to break things. The relationships have all
disappeared and I now have a few orphan records wandering around.
Assuming
she didn't proactively delete them, does anyone know of any circumstance
whereby they could be accidentally deleted? I have no idea how this
happened and obviously don't want it to happen again.

If anyone has any ideas, let me thank you in anticipation.

Linda