Reset path for linked tables

B

Bob Scullen

I have linked tables identified as C:\folder\file. How do I reset this to
\\name\\shared folder\filename? I'm assuming I need to use the Linked Table
Manager, but it's not clear to me how to do it. Thanks for your help.
 
R

Roger Carlson

You can use the Linked Table Manager OR you can delete the table and re-link
it with File>Get External Data. Either way, when you browse to the file,
don't use the mapped drives, but go down to the bottom where you'll find the
Network Neighborhood and browse to the file from the server on down.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
 
P

Paradigm

I use the following code to delete the table and reattach it

DoCmd.DeleteObject acTable, "mytable"
Set tbl = currentdb.CreateTableDef("mytable")
tbl.Connect = ";Database=" & PathandFilenameofMDBfileContainingMytable
tbl.SourceTableName = "mytable"
currentdb.TableDefs.Append tbl


Alex
 
Top