Deleted Table Relationship (AND table) still exists...

[Hendy88]

Hello,

I created a table from the table wizard called Customers and then
another called Order Details. I was playing around setting some
relationships between them (just to see how it worked). When I was
finished, I was in the Relationship editor, right clicked on the line
that connected the two tables and deleted the relationship. I then
when into the Tables and physically deleted the Order Details table.

After that I thought all was fine and dandy, but when I double clicked
back into the Customers table, I still saw the "plus sign" to the left
of all my records (which appeared when I made the relationship
earlier). Even though I just deleted the relationship AND the table it
was relating to, it still wants to relate to that other table. In
fact, when I click on the plus sign it comes up with a window saying
"The table or query name 'Order Details' you entered in either the
property sheet or macro is misspelled or refers to a table or query
that doesn't exist."

Am I missing something? Did I not delete the relationship right? Or
am I supposed to do another step to "unrelate it"? I looked in
Queries, Forms, Macros, etc. but there's nothing in there.

Any help would greatly be appreciated. I'm using Access 2003 BTW.

Thanks,
Steve B

 

[tina]

try running a compact/repair from the Tools menu, if you haven't already. if
that doesn't help, then did you turn OFF the Name Autocorrect option when
you created the database? if not, suggest you create a new, blank database.
immediately turn OFF the Name Autocorrect option from the database window's
menu bar, under Tools | Options | General tab. compact the database, then
import all the objects from your working database. compact again.

hth

 

[John Vinson]

Am I missing something? Did I not delete the relationship right? Or
am I supposed to do another step to "unrelate it"? I looked in
Queries, Forms, Macros, etc. but there's nothing in there.

I'd suggest getting rid of Name Autocorrect (cynically referred to by
many as Name Autocorrupt). Open the database; select Tools...
Options... General; uncheck "Track Name Autocorrect Information".

Compact the database to get rid of the name autocorrect residue
(Tools... Database Utilities... Compact and Repair) and see if this
helps.

Most developers will also set all tables' Subdatesheet property to
[None] rather than [Auto] - you shouldn't be using table datasheets
for interaction with your data anyway, and the subdatasheets can be a
major drain on performance.

John W. Vinson[MVP]

 

[Van T. Dinh]

I think it meams that the SubDatasheet Name of the Table Customers still
points to the deleted Table [Order Details].

Open the Table Customers in Design View then open its Properties window and
you should see the "SubDatasheet Name" Property. Set this to "None" and
blank out the next 2 Properties (Link Child Fields, Link Master Fields).
Save the Table and the Plus sign should disappear.