Getting the drive and directory info of an access database

[Matt_Hirst]

I have written a small access database, it sits in d:\matt directory. In the modules I have referred to the database path c:\matt, obviously if I move the database it'll produce an error. What do I need to do so that the database looks at it's current location\path and continues working no matter what hard drive or directory it is located in?

Also if I split the database into a front end / back end system what maintains the links between the two databases? Can these be referenced if so how?

regards,

Matt

 

[mhartman]

Hello:

The Environ function may help you with this task: Such as

=Environ("USERPROFILE")
=Environ("windir")
Put these examples in the control source of a text box

There are about 50 different constants depending on your Access version.

Search Environ in help for the complete list.
Regards
Mark

 

[Cosmos75]

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

Hope that helps!

 

[Matt_Hirst]

Thanx for the help guys, I managed to figure it out.

regards,

Matt