Linked Text file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Database Girl - 21 Jan 2008 14:43 GMT

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

Reply to this Message

Arvin Meyer [MVP] - 21 Jan 2008 14:48 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

>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.
[quoted text clipped - 6 lines]
>
> Thanks

Reply to this Message

Daniel Pineault - 21 Jan 2008 15:01 GMT

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.

Signature

Hope this helps,

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

> Using network neighborhood, you should be able to use UNC (Universal Naming
> Convention) to map to a network share.
[quoted text clipped - 12 lines]
> >
> > Thanks

Reply to this Message

Arvin Meyer [MVP] - 21 Jan 2008 15:14 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Just to follow in what Arvin said, you can find code to convert named
> drive
[quoted text clipped - 21 lines]
>> >
>> > Thanks

Reply to this Message

Database Girl - 21 Jan 2008 15:23 GMT

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

> Just to follow in what Arvin said, you can find code to convert named drive
> into UNC format at
[quoted text clipped - 19 lines]
> > >
> > > Thanks

Reply to this Message

Arvin Meyer [MVP] - 21 Jan 2008 15:32 GMT

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.

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> 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
[quoted text clipped - 27 lines]
>> > >
>> > > Thanks

Reply to this Message