• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1105
  • Last Modified:

Unlinking A linked Table

Is there a simple way to unlink a linked table in Access 97?
0
mcuevas
Asked:
mcuevas
  • 2
  • 2
1 Solution
 
berg1375Commented:
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.


berg
0
 
tomk120999Commented:
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...
0
 
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.
0
 
berg1375Commented:
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.

berg
0
 
mcuevasAuthor Commented:
Well thanks anyways.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now