Current Directory code

[Nick]

I currently have my database code referencing the
database by using

Const DB = "c:\windows\perryni\DRisk.mdb"

is there any other way i can do this without writing the
specific path down as this database may be moved around.

Cheers

Nick

 

[Alex Dybenko]

you can use
CurrentDB.name

 

[Nick]

Thanks, i am a bit of a novice at this, how do implement
CurrentDB.name

 

[Alex Dybenko]

instead of:
Const DB = "c:\windows\perryni\DRisk.mdb"

declare a variable:
dim DB as string
and initialize it:
db=currentdb.name

or just replace your constant DB with currentdb.name