×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help with Linked tables

Help with Linked tables

Help with Linked tables

(OP)
I have an existing Access 2000 database (.mdb). It has many linke dtables in it.  I am trying to change a table's specs. but can't get to it since it's linked. If I take the link away the table disappears.  Is it still in the .mdb?  Microsoft says that you can re-l;ink to it again....but not if it's not there??  All I need to do is edit some of the field sizes within that table.  Can anyone help me on this one please!

Jim

RE: Help with Linked tables

The "table" you see in the database window for a linked table is like a desktop shortcut. It's only a reference to a table that exists elsewhere, namely, in another database, or in an Excel spreadsheet or a text file.

To relink it, you need to know where the database is that contains the real table. (That's also where you'll need to edit your field sizes.)

Chances are, it's in the same database as another of your linked tables. If you run the Linked Table Manager (Tools>Add-Ins menu in Access 97; Tools>Database Utilities menu in Access 2000), it will show you the path names to external files that contain each of the linked tables.

Rick Sprague

RE: Help with Linked tables

(OP)
Hey Thanks, that did the trick!  

Jim

RE: Help with Linked tables

I just made a combo box to a form how do i get the information in the combo to add a table (the table is a linked table won't let me edit) You can email me at Twilleez@home.com Thank you

RE: Help with Linked tables

I am trying to export a access table to a dbase format table for use with other applications, I can do it manually with the export function in access (transferdatabase doesnt seem to work in access basic).. I would like to automate it in VB but cannot find a way to do it.. any help available?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close