Results 1 to 5 of 5
  1. #1
    HeyMoe is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2023
    Posts
    8

    Database on a USB drive and Linked Tables/Files.

    I have a database stored on a USB drive.
    When linking tables/external data files/etc, is there a way I can choose the linked table/file relative to where the front end is?
    ie. Not needing to use drive letters, but something like ../directory/abcd.txt.

    You see, when I open the database on another PC or laptop, the drive letter assigned to the USB drive can be different, therefore the database doesn't find the linked table.

    Thanks.
    M.C

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Are you saying db is split and both frontend and backend and any other associated files are on USB?

    Have to relink tables using LinkedTableManager or VBA which can determine drive letter from frontend's path.

    Left(CurrentProject.Path, 1)
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    HeyMoe is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2023
    Posts
    8
    LinkedTablelManager is no good, because I will need to relink every time I use the database.

    Using VBA may be the way to go. I'll give it try.

    Thanks!

  4. #4
    moke123's Avatar
    moke123 is online now Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,643
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Hardly need to download a third-party product. The code is not difficult and this is a common topic.

    Here is one https://stackoverflow.com/questions/...les-access-vba
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 20
    Last Post: 09-08-2020, 10:40 AM
  2. Opening Files from a network drive
    By hinchi1 in forum Access
    Replies: 5
    Last Post: 06-10-2018, 04:04 AM
  3. Replies: 5
    Last Post: 11-20-2017, 11:28 AM
  4. Replies: 11
    Last Post: 09-07-2017, 09:20 AM
  5. Replies: 1
    Last Post: 03-13-2014, 10:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums