UNC Question

[golfinray]

I use unc to link all my tables from FE to BE. Most are like
\\arserver\fileshare\My.mdb Some users, because the IT people won't allow
us to set everything up the way we want it, don't have the fileshare folder.
They are just \\arserver\my.mdb Is there any way to automate when I update
the FE so I don't have to go through theirs and relink all the tables? Thanks!

 

[Stefan Hoffmann]

hi,

I use unc to link all my tables from FE to BE. Most are like
\\arserver\fileshare\My.mdb Some users, because the IT people won't allow
us to set everything up the way we want it, don't have the fileshare folder.
They are just \\arserver\my.mdb

afaik this is not possible. SMB needs the \\server\share\[path\]file
structure.

Is there any way to automate when I update
the FE so I don't have to go through theirs and relink all the tables? Thanks!

e.g. AutoFE:

http://www.autofeupdater.com/


mfG
--> stefan <--

 

[Jack Leach]

I would think a FileExist function to check the status of the passed folder
would do. Pass the default, if it doesn't exist, change the path to the
other (presumable checking this existence of this as well, for good measure).

You can write an handy fileexist function by using GetAttr on a filepath,
catching the error that will occur if it doesn't exist. You can probably
google for one as well (that's where I got mine). If you do need it let me
know I'll dig it out of my util library.


Ex. (aircode)

For Each tbl In Tabledefs
strPath = "\\arserver\fileshare\My.mdb"
If Not FileExists(strPath) Then
strPath = "\\arserver\My.mdb"
End If
strConnect = strConnect & strPath
tdl.Connect = strConnect
tbl.RefreshLink
Next tbl

obviously you'd want your code with a bit more verifications, etc, but the
idea's there anyway.

hth
--
Jack Leach
www.tristatemachine.com

"I haven''t failed, I''ve found ten thousand ways that don''t work."
-Thomas Edison (1847-1931)