Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-11-2012, 09:05 AM   #1
mark95616
Newly Registered User
 
Join Date: Jun 2012
Posts: 17
Thanks: 7
Thanked 0 Times in 0 Posts
mark95616 is on a distinguished road
Linked tables

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.

mark95616 is offline   Reply With Quote
Old 11-11-2012, 10:22 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 33,285
Thanks: 13
Thanked 4,111 Times in 4,043 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Linked tables

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.
__________________
Paul
Microsoft Access MVP 2007-2019

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is offline   Reply With Quote
The Following User Says Thank You to pbaldy For This Useful Post:
mark95616 (11-11-2012)
Old 11-11-2012, 01:22 PM   #3
mark95616
Newly Registered User
 
Join Date: Jun 2012
Posts: 17
Thanks: 7
Thanked 0 Times in 0 Posts
mark95616 is on a distinguished road
Re: Linked tables

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.

mark95616 is offline   Reply With Quote
Reply

Tags
links , split

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Linking Tables and Creating Reports based on those linked tables rexmorgan Tables 1 01-30-2011 08:03 PM
Linked Tables, Local Tables and ODBC lcbateman3 Tables 2 01-23-2009 04:40 AM
Number of Sub Tables linked to Main Tables chris11590 Tables 16 09-04-2008 06:22 AM
Changing Linked Tables into Regular Tables rheide General 3 12-27-2007 08:57 AM
Linked Tables to Local Tables Problem jennilewis Tables 0 08-26-2005 01:47 AM




All times are GMT -8. The time now is 09:40 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World