reroute drive

[DUX]

sorry, i am very new to access and have been thrown into some already completed tables. one of my tables has a link on it (with an arrow beside it)...and when i click on it to look at the table, i get the error:

'C:\intranet\personal\personal.mdb' isn't a valid path. make sure that the path name is spelled correctly and that you are connected to the server which the file exists.

the issuse with this error is that the table i want to get at, isn't on C:\, it is on another drive. how do i redirect this link to a different drive. sorry for the dumb question, but i am kinda clueless and thought you people might be able to help me out.

Thanks,

Dux

 

[ghudson]

You need to relink the table...

Tools / Add-Ins / Linked Table Manager

HTH

 

[DUX]

ok, i got there fine, but i can seem to manipulate the line that is already in place. what do i need to do to change it?

Thanks,

Dux

 

[The_Doc_Man]

At least in my current version of Access (97), you can't "fix" the broken link. (Or at least, I've somehow never quite gotten that to work right.) But you CAN replace it.

Basically, you have to find the correct device and path to what you wanted. Write down the correct name of the linked table. Look for queries and relationships using this table. Take good notes. You'll need them later.

When done, delete the table.

Now, from the Access window, Tables pane, you would do a File>> Get External Data>> Link to build a new link to the table in its new location but with the right table name to match the prior incarnation of that table.

Now go back to all the relationships, queries, etc. that used this table. (This is the stuff you wrote down earlier.) Rebuild the entities that used this table. That would be all relationships and queries. For forms and report, you might just get away with reopening the object in design mode, then verify that the names of the bound fields have all be retained.

 

[DUX]

i'm sorry, but i now have more stupid questions....

Write down the correct name of the linked table.
- i assume this is just where the table is that i really need to link?


Look for queries and relationships using this table.
- being so new, i am not sure i understand how i go about doing this part?


Now, from the Access window, Tables pane, you would do a File
- how do i do a file from the tables pane? it isn't the main file at the top left of the access page, is it?


i guess that is all my questions up to this point.

Thanks,

Dux

 

[Pat Hartman]

To use the linked tables manager, simply check the table you want to relink and check the "always prompt" box at the lower left of the form. Then click OK to see the common file dialog that you can use to point to the new table location.

 

[DUX]

Great, "always prompt" would work, but apparently it has been set up as read only and won't allow me to change it. is there an easy way to make this NOT read only, so that i can fix this link?

Thanks for your help,

Dux

 

[Pat Hartman]

I know of no way to make these links read-only. Is the database secured and do you have a permissions problem?

 

[DUX]

I am completely confused, but it is now working. I went back and tried again today (the steps you had told me to do) and it worked. I do not know why it wouldn't allow me to do it last week, saying that it was view/read only? But, it works now and I guess that is all that counts.

Thanks for your help,

Dux