Linked tables (1 Viewer)

mark95616

Registered User.
Local time
Today, 00:18
Joined
Jun 17, 2012
Messages
17
I split an Access database in Access2007. I inadvertently then established another link to these tables (several times). Now when I go to the linked tables manager instead of just being linked to Table TblActions the front end is linked to TblActions, TblActions1, TblActions2, TblActions3 and so on for all the tables.
I cannot find a way to get rid of the links to these other tables, I am not sure if they are just instances of the true table either.
How do I get rid of these phantom links.
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 00:18
Joined
Aug 30, 2003
Messages
36,125
You should be able to right-click and delete. As long as it has the little arrow next to it, it is a linked table and all you're deleting is the link.
 

mark95616

Registered User.
Local time
Today, 00:18
Joined
Jun 17, 2012
Messages
17
Yes thanks, the tables were not showing up in project explorer window in VBA, once I made the folder a non trusted site they did and it was easy to erase the links. Any idea of why the tables do not show up as Access Objects when I make that folder a trusted site.
 

Users who are viewing this thread

Top Bottom