HELP!! Still can't change the path on my linked tables

B

Bob Scullen

I can't change the path for my linked tables to \\network place\\shared
folder\shared file. I haven't been able to do it in the Linked Table Manager
and the VB code I've tried based a couple of replies doesn't work. If
anybody can supply some additional guidance, I'd be VERY grateful. Thanks
 
A

Andi Mayer

I can't change the path for my linked tables to \\network place\\shared
folder\shared file. I haven't been able to do it in the Linked Table Manager
and the VB code I've tried based a couple of replies doesn't work. If
anybody can supply some additional guidance, I'd be VERY grateful. Thanks
Click to expand...

is this a Typo? \\network place\\shared
should read \\network place\shared
 
A

Andi Mayer

is this a Typo? \\network place\\shared
should read \\network place\shared
---
Click to expand...

what isn't working with "Paradigm" <[email protected]> code?

Dim tbl as DAO.Tabledef
dim db as DAO.Database
dim stCon as string
Set db=currentdb
stCon="\\network place\shared folder\shared file"
db.Tabledefs.delete "MyTable"

Set tbl = currentdb.CreateTableDef("mytable")
tbl.Connect = ";Database=" &stcon
tbl.SourceTableName = "mytable"
db.TableDefs.Append tbl
db.Tabledefs.refresh

set tbl= nothing
set db=nothing
 
B

Bob Scullen

Andi, thanks very much for your help. The code you sent worked fine. I was
missing the db.TableDefs.refresh line and didn't know enough to put it in. I
suspect that was my problem. thanks again!!! Bob Scullen
 
A

Andi Mayer

Andi, thanks very much for your help. The code you sent worked fine. I was
missing the db.TableDefs.refresh line and didn't know enough to put it in. I
suspect that was my problem. thanks again!!! Bob Scullen
Click to expand...
your welcome

next time add the code, which makes you troubles then it's easier
in this case I added three or four lines to an existing code, but I
had to search for the original first
 
Top