How To Get Frontend and Backend UNC Paths?

[Wayne]

I'm using the following to get the FE and BE database paths.

FEPath = DBEngine.Workspaces(0).Databases(0).Name

BEPath = Mid([DBEngine].[Workspaces](0).[Databases](0).[TableDefs]
("Admin").[Connect], 11)

These work well but they only retrieve the Drive Letter paths. Is
there a simple way to retrieve the UNC paths?

[Wayne Gillespie]

On Wed, 16 Jul 2008 17:53:12 -0700 (PDT), Wayne <cq*******@volcanomail.com>
wrote:

>I'm using the following to get the FE and BE database paths.

FEPath = DBEngine.Workspaces(0).Databases(0).Name

BEPath = Mid([DBEngine].[Workspaces](0).[Databases](0).[TableDefs]
("Admin").[Connect], 11)

These work well but they only retrieve the Drive Letter paths. Is
there a simple way to retrieve the UNC paths?

It depends on how the table was linked initially.
If the table was linked using a drive letter, the connect string will return the
drive letter.
If the table was linked using a UNC path, the connect string will return the UNC
path.

There is no inbuilt conversion function, it is just a text string.
Wayne Gillespie
Gosford NSW Australia

[Salad]

Wayne wrote:

I'm using the following to get the FE and BE database paths.

FEPath = DBEngine.Workspaces(0).Databases(0).Name

BEPath = Mid([DBEngine].[Workspaces](0).[Databases](0).[TableDefs]
("Admin").[Connect], 11)

These work well but they only retrieve the Drive Letter paths. Is
there a simple way to retrieve the UNC paths?

This should help. http://www.mvps.org/access/api/api0003.htm

Eye of the Tiger
http://www.youtube.com/watch?v=eMsBU0zvMqc

[Wayne]

Thanks for the help Wayne and Salad.

[JvC]

Wayne,

You can use CurrentDb.Name to get the FEPath. It's a bit shorter!

Wayne expressed precisely :

I'm using the following to get the FE and BE database paths.

FEPath = DBEngine.Workspaces(0).Databases(0).Name

BEPath = Mid([DBEngine].[Workspaces](0).[Databases](0).[TableDefs]
("Admin").[Connect], 11)

These work well but they only retrieve the Drive Letter paths. Is
there a simple way to retrieve the UNC paths?

[Stuart McCall]

"Wayne" <cq*******@volcanomail.comwrote in message
news:dd**********************************@l42g2000 hsc.googlegroups.com...

I'm using the following to get the FE and BE database paths.

FEPath = DBEngine.Workspaces(0).Databases(0).Name

BEPath = Mid([DBEngine].[Workspaces](0).[Databases](0).[TableDefs]
("Admin").[Connect], 11)

These work well but they only retrieve the Drive Letter paths. Is
there a simple way to retrieve the UNC paths?

Yes. All it requires is a little copy 'n paste from here:

http://www.smccall.demon.co.uk/MiscApi.htm#UNCpath

[David W. Fenton]

JvC <jo******@earthlink.netwrote in
news:Pp*****************@newsfe04.iad:

You can use CurrentDb.Name to get the FEPath. It's a bit shorter!

And more reliable, since it can never return anything but the
database open in the Access UI. DBEngine(0)(0) can in rare
circumstances (such as just after running a wizard) return a
different database.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/