Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Location
    Burnley, Lancashire, England
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    vba code needed to find directory of database (2000)

    I have a batch file that opens computer management and it is located in the same directory as the database, the vba code looks in a set location.

    The problem is that when a different person wants to view the database on their own m/c, the location is different.
    e.g.
    * my database dir
    c:documents and settingsdanejmydocumentsdatabasessoftware Audit

    * other persons dir
    c:documents and settingsUser Namemydocuments"database location"

    how do i find out the location of the database so then i can add the batch file name at the end of the location

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: vba code needed to find directory of database (2000)

    Checkout <post#=166920>post 166920</post#>.

    Pat

Posting Permissions

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