Database Path

[prizm]

Using Access97, I am trying to set up folders (with MkDir) within the same folder as the Database. The users of this database cross servers so using CurDir only provides the path of the user's FileSystem. How can I find the path where the database is? Thanks.

 

[KenReay]

Dim dbsCurrent As DAO.Database
Fim strTmp As String

Set dbsCurrent = CurrentDb()
strTmp = dbsCurrent.Name

yoy need a reference to DAO to use above

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[goaway1234]

CurrentDb.Name holds the full path to the database.