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

[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

 

[TC]

All,

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

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

Now, I link tables from datamdb into link.mdb.

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).

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.

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

 

[Guest]

-----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

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

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"

I'll try this. Thanks.

-Mark

 

[TC]

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

 

[Guest]

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