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 programmatically 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.meganewsser vers.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
