Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    database location property (2000)

    How can I read the database location? It isn't listed as a database property nor is it included in the SummaryInfo Collection. Perhaps there is a better way to discover the location of the database. I want to know where the database is located so that I can attach a setup database located in the same directory then extract more information from it.

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: database location property (2000)

    I'm not sure what you mean by a setup database. If you want to know where the mdb itself is located, you can get at it in code by using CurrentProject.Path, which will return the folder in which the mdb lives. If you also need the name of the file, use CurrentProject.FullName. However, keep in mind that if you are doing this from *another* database, you'll have to do it a bit differently.
    Charlotte

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Chatham, Ontario, Canada
    Posts
    86
    Thanks
    5
    Thanked 1 Time in 1 Post

    Re: database location property (2000)

    Thank you Charlotte. That was exactly what I was looking for.
    I'm sorry my explanation was confusing. I was sure that the explanation would be simple and that I was just using the wrong words when searching through help. I had thought that a brief explanation of my objective would help but it seems I used the wrong words there too.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •