Display database location

[mattkorguk]

Hi All,
Is it possible to retrieve/ display the location of a database?

The reason is that we have various versions, 97, 2000, 2003 which include some read only version as well and I'd like to trap the username and date etc together with the location/ version.

I've got the first bits sorted, just not the location, any ideas?

Thanks
Matt

[JKing]

Here's a link to microsoft that details getting the path/fullpath for a database.

http://support.microsoft.com/kb/210395

[ADezii]

Hi All,
Is it possible to retrieve/ display the location of a database?

The reason is that we have various versions, 97, 2000, 2003 which include some read only version as well and I'd like to trap the username and date etc together with the location/ version.

I've got the first bits sorted, just not the location, any ideas?

Thanks
Matt

Debug.Print CurrentDB.Name will return the Absolute Path to the Current Database as in:
[CODE=vb]Debug.Print CurrentDB.Name [/CODE]
OUTPUT
C:\Documents and Settings\securi ty\My Documents\Test. mdb