Database File Path (1 Viewer)

[GUIDO22]

Is there a simple way of determining the exact file path for the current database using VBA? I have tried using CurDir() but this does not return the DB file - but MyDocuments on another drive.....???

 

[PeterF]

currentdb.name gives the full databasename,
use left(currentdb.name , InStrRev(currentdb.Name , "\") ) to get only the path.

 

[GUIDO22]

InStrRev - my guess this function is new and does not appear to be available in Access '97..... I guess I will have to write my own... unless you know of an alternative..????

 

[jubb]

Hi,

try

CurrentProject.Path

this will give you the full file path to your current db

Cheers

 

[GUIDO22]

Hi,

try

CurrentProject.Path

this will give you the full file path to your current db

Cheers

Sorry Jubb - but as stated I am using 97 and this covention is not permitted in this version......

 

[PeterF]

Try the instrrev function found here

 

[jubb]

Hi,

Not sure if you worked this out or not but the following should work in access97.

'returns the current database file name
Dir(CurrentDb.Name)

'Returns the current database path
Left(CurrentDb.Name,Len(CurrentDb.Name)-Len(Dir(CurrentDb.Name)))

'Returns the current database path and the file name
CurrentDb.Name

Thanks
Jubb

 

[Cosmos75]

File Name, File Path, And Microsoft Access Version Number Of Current Database File And Microsoft Access Application

Hope that helps!