By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,203 Members | 1,358 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,203 IT Pros & Developers. It's quick & easy.

The Case of the Disappearing Relationships

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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*********@SeeSig.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 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


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.