+ Reply to Thread
Results 1 to 3 of 3

Access Database on a shared drive

  1. #1
    Registered User
    Join Date
    01-07-2020
    Location
    Columbus, Ohio
    MS-Off Ver
    2019
    Posts
    70

    Question Access Database on a shared drive

    Hello. I put an Access form linked to a database on a shared drive for people in my group to use, but we have run into an issue. When connecting to the shared drive, you select the prefix (for example, Z:, I:, etc.) depending on what drive letters you still have open. I am connected to quite a few, so I chose Z: as my prefix, so the path from the Access form to the database that I set is Z:\Folder1\Folder2\Database.accdb (example names). However, if someone is trying to use it who has a different prefix for their drive, they cannot open it. Is it possible to fix this issue without requiring everyone to change their drive prefix? Thanks in advance!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs
    MS-Off Ver
    MS Office 2019
    Posts
    18,254

    Re: Access Database on a shared drive

    Use a full UNC file path. A UNC path is the path to a folder or file on a network and contains the server name in the path. For example, \\server01\sage\jobcosting This avoids the issue you are having.

  3. #3
    Registered User
    Join Date
    01-07-2020
    Location
    Columbus, Ohio
    MS-Off Ver
    2019
    Posts
    70

    Re: Access Database on a shared drive

    Sorry for the delay, but I wanted to let you know that worked perfectly. Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 0
    Last Post: 05-07-2020, 07:16 PM
  2. Shared Drive hyperlink problem 'No database connected to this view'
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-07-2014, 04:42 AM
  3. Replies: 4
    Last Post: 03-13-2014, 11:22 AM
  4. Replies: 0
    Last Post: 09-18-2013, 04:17 PM
  5. Replies: 2
    Last Post: 07-05-2013, 09:37 AM
  6. Excel 2007 Loader to Access. Error running on shared network drive
    By jvbeats in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2013, 11:54 AM
  7. Is it possible to run a macro to upload Access DB to a shared drive?
    By JasonPsychoSO242 in forum Access Tables & Databases
    Replies: 4
    Last Post: 12-28-2012, 02:58 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1