Can't delete or open a link. What gives?

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

All,

I have an access database (call it link.mdb) that has
linked tables to another access database (call it
data.mdb).

Now, I link tables from datamdb into link.mdb. When I try
to open one of those linked tables, nothing happens (no
error, no display). When I try to delete the link, I can't
(no error is displayed).

I'm stumped. I've tried compacting both the databases, and
also tried reimporting the objects into a new link.mdb.

Any help is greatly appreciated. this is making me look
bad at a job I just started.

-Mark
 
Mark said:
All,

I have an access database (call it link.mdb) that has
linked tables to another access database (call it
data.mdb).
Click to expand...

So link.mdb has links to actual tables in data.mdb.

Now, I link tables from datamdb into link.mdb.
Click to expand...

Do you mean that data.mdb also has links to actual tables in link.mdb?

When I try
to open one of those linked tables, nothing happens (no
error, no display). When I try to delete the link, I can't
(no error is displayed).
Click to expand...

Surely *something* must happen? Are you saying that when you select a link
from the Access UI, then press the Del key, *absolutely nothing* happens?

I'm stumped. I've tried compacting both the databases, and
also tried reimporting the objects into a new link.mdb.

Any help is greatly appreciated. this is making me look
bad at a job I just started.
Click to expand...

Maybe try deleting through code. Though personally, I would not do that
until I'd worked out what was going on. Be sure to take a backup copy of
each database first.

dbengine(0)(0).tabledefs.delete "MyTable"


HTH,
TC
 
-----Original Message-----



So link.mdb has links to actual tables in data.mdb. Yep.

Do you mean that data.mdb also has links to actual tables
Click to expand...
in link.mdb?

No, sorry. I'm creating linked tables in link.mdb. Those
links point to native tables in data.mdb.
Surely *something* must happen? Are you saying that when you select a link
from the Access UI, then press the Del key, *absolutely
Click to expand...
nothing* happens?

Well, it does ask me if I want to delete the link. When I
click "Ok", the link doesn't delete, nor do I get any
error.

I click on "design" and nothing happens. I try to open,
nothing happens.
Maybe try deleting through code. Though personally, I would not do that
until I'd worked out what was going on. Be sure to take a backup copy of
each database first.

dbengine(0)(0).tabledefs.delete "MyTable"
Click to expand...
I'll try this. Thanks.

-Mark
 
It sounds to me like one or both db's are corrupt. I would create two new
db's, import all the (non-link) objects, then relink the new links.db to the
new data.db & see if that fixes it.

HTH,
TC
 
Thanks TC,

That's probably the best option. Hopefully that works. If
it's not that, it may be my msaccess.exe program is
somehow corrupt.

-Mark
 
Back
Top