Access DB path

[zliazmei]

Hi all!

Does anybody knows how can I retrieve the current access DB path in VB.
I am trying to solve a problem : the Dbase when moved into another folder will retrieve it new location.

Thanks!

Zmei

 

[johnwm]

Look up the CurDir function

Good Luck
johnwm

 

[zliazmei]

10X John!

I can not uderstand why yest dhe curdir() was returning the corect path, and today it is returning c:\doc&set\......

WHY???

ZMei

 

[dsi]

Ahh, CurDir will return the active Windows directory, not the file's path. If you are using Access VBA, you can use CurrentProject.Path to return the path of the active database.

DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

 

[zliazmei]

Thanks a lot!!!!!

Dsi, you saved my life!

ZMEI