Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    current drive (A2K)

    I have a database my boss wants to run from a cd
    the problem is there are several links to tables and images not in that database
    and the cd may be a different drive letter on different machines but he wants to be able to run it from any machine
    is there any way to put the drive letter the database is running on into the code in that database when the database opens up
    TIA

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

    Re: current drive (A2K)

    In the code use CurrentProject.Path to return the path for the current database or CurrentDb.Name, which returns the full path, including the name of the database file. Links to images and tables that are not in the database or on the CD won't work unless they just happen to be in the same place on every machine or unless they *are* on the CD and are relinked in code when the database is opened. Unfortunately, the database on the CD is going to be read-only, so I suspect that you won't be able to relink tables on the fly. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Tennessee
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: current drive (A2K)

    Thanks Charlotte
    I'll give it a try later just to see if it will work with a cd
    the database will only be used for showing the types of
    data we record. So the read only should not be a problem

Posting Permissions

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