Unlinking A linked Table

Is there a simple way to unlink a linked table in Access 97?
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

This is as simple as it gets:

Delete the link to a linked table

1      In the Database window, click the Tables tab, and then click the linked table.
2      Press the DELETE key. Microsoft Access deletes the link and removes the table's name from the list.

Note   When you delete a linked table, you are deleting only the information that Microsoft Access uses to open the table, not the table itself. You can link to the same table again later if you want.

Hope this doesn't sound like a dumb remark, but I unlink by simply deleting the linked table name (select table, press 'Delete', answer 'Yes').  This removes only the link in the current DB, not the table in the other database.

I have done the same thing programatically in VBA.

Hope that helps.
good luck as usual...
mcuevasAuthor Commented:
I'm sorry, maybe you misunderstood me. I want to delete the link in the database that I am working on right now, but I want to keep the table in it also.
You will have to import the table once the link is deleted. As far as I know you can't delete the link and keep the table.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mcuevasAuthor Commented:
Well thanks anyways.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.