When deleting Linked Table, Access crashes

[WEs]

Hi List,

I'm trying to delete a linked table and the program
crashes. Can you help?

Thanks

 

[Guest]

I seem to recall the same problem. The linked table was an "orphan"... the
backend didn't exist where the mdb thought it should (table MSysObjects,
Database field).

I'd suggest a creating a new mdb, add any references required and import all
but the linked table you want to delete.

Steve

 

[Eric I]

I had a similar problem a few months ago. I took the MDB
that was having the problem opened it on another machine
with Windows XP and Access 2002, recompiled it and saved
it and closed it and I believe that was what cleared it
up. The MDB occasionally would get corrupted on my
Windows 2000 development machine, but opening it on the
other machine cleared up the problem for both machines. I
don't pretend to understand why it worked, but it did for
me.

Hope that helps!