Linked Text file

[Database Girl]

I need to relink to a text file on a share drive, but I want to link
according to the data path value instead of the share drive letter.

Ex:
//cdf888/example
Instead of c:/example

Any idea on how I can do this.

Thanks

 

[Arvin Meyer [MVP]]

Using network neighborhood, you should be able to use UNC (Universal Naming
Convention) to map to a network share.

\\ComputerName\ShareName\OptionalFolderName\FileName.mdb

Access will recognize this and continue to open the file.

 

[Daniel Pineault]

Just to follow in what Arvin said, you can find code to convert named drive
into UNC format at

http://www.mvps.org/access/api/api0003.htm

the fGetUNCPath function specifically.
--
Hope this helps,

Daniel Pineault
If this post was helpful, please rate it by using the vote buttons.

 

[Arvin Meyer [MVP]]

That code returns existing UNC connections (plus all other drives and
mappings), but not one that isn't already connected. The mere existence of a
share does not necessarily mean that you are connected to it, or for that
matter even have permissions to connect to it.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Database Girl]

Great suggestions, however I am working with Access 97 and I am trying to
link to a text file on a share drive. Is there a easier way to change the
UNC name besides writing code?

Thanks

 

[Arvin Meyer [MVP]]

The UNC is a share on the server (or any other computer on the network) You
get to it by using Network Neighborhood or My Network Places and finding the
other computers on your network. If there is a share defined on that
computer, and you have permissions to it, you simply click on it and choose
connect. You will then see all the folders and files in that share. You do
not need to use the code at the Access Web at all.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com