How to detect the drive letter

#1

Dear reader,

What is the syntax in VBA to check de drive letter of the folder where in
the application is running.

Not the drive letter of the linked tables but the one where the front-end is
located.

Thanks for any help.

Simon

#2

Wayne thanks it works perfect.

"Wayne Gillespie" <bestfit (AT) NObestfitSPAMsoftwarePLEASE (DOT) com.au> wrote in
message news:n5av15le53janaqh966m72ggd7rb7j5i7d (AT) 4ax (DOT) com...

Quote:

On Fri, 29 May 2009 11:06:11 +0200, "Simon" <SvanBeekNL (AT) Versatel (DOT) nl
wrote:

Dear reader,

What is the syntax in VBA to check de drive letter of the folder where in
the application is running.

Not the drive letter of the linked tables but the one where the front-end
is
located.

Thanks for any help.

Simon

Left(CurrentDb.Name,1)

Wayne Gillespie
Gosford NSW Australia

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to detect the drive letter

comp.databases.ms-access comp.databases.ms-access

How to detect the drive letter - 05-29-2009 , 04:06 AM

Re: How to detect the drive letter - 05-30-2009 , 03:14 AM