Re: VBA for Path of Current MDB

"undrline via AccessMonster.com" <u28594@uwe> wrote in message news:89670109a9d89@xxxxxx
I want to relink tables based on the current path of the file (second mdb
will always be in the same directory as the first). I have the module all
set up for relinking. I just need to know how to get at the current path.
Does Access know what directory the current file is located in? How do I get
at that in VBA? Will it return the UNC path or the logical path, or can I
choose?


In Access 2000 and later, CurrentProject.Path gives the folder path. If that's a network path, I don't know for sure whether it will be the UNC path or not. However, you really should not be running the front-end database from a network share, as that is more corruption-prone.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

.

Relevant Pages

  • Re: Getting the physical path of network drive.
    ... used it to resolve a UNC path to a local directory recently ... i want to check first if this path (network path) exist of his ... I think that i need to use "WNetGetResourceInformation" win api ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: IIS access a network share
    ... > You can't use a mapped drive as that only exists in the context of a ... > logged on user's environment. ... You need to use UNC path instead. ... accessing the network path requires a ...
    (microsoft.public.inetserver.iis)
  • Re: Accessing network folders using filesystemobject
    ... Devapriya De Silva wrote: ... I run it in IIS/ASP. ... > What I meant by network path is a UNC path. ...
    (microsoft.public.scripting.vbscript)
  • Re: Accessing network folders using filesystemobject
    ... >> What I meant by network path is a UNC path. ... > Michael Harris ... > Sammamish WA US ...
    (microsoft.public.scripting.vbscript)