If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
UNC Question
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! -- Milton Purdy ACCESS State of Arkansas |
#2
|
|||
|
|||
UNC Question
hi,
golfinray wrote: 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 -- |
#3
|
|||
|
|||
UNC Question
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) "golfinray" wrote: 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! -- Milton Purdy ACCESS State of Arkansas |
Thread Tools | |
Display Modes | |
|
|