Results 1 to 3 of 3
  1. #1
    DomSza is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2016

    Refresh Data in Excel on User's PC

    Hi all,

    I'm working on a new data management system for our business using Microsoft Access 2016. We have been using it for a while to connect various spreadsheets to a single data source.

    The issue I'm having is that I can only refresh the data on each spreadsheet from the computer that the connection was set up on. For example, the Data Connection to Access on Spreadsheet A uses the reference C://Users/Dom/database.accdb, which works perfectly fine on my computer. When I run this on someone else's computer, it obviously cannot find the path C://Users/Dom/database.accdb.

    Is there a way to update data in excel with a variable file path based on the User's computer? I'm quite familiar with VBA so I'm not opposed to including a macro on each spreadsheet which updates data.

    Thanks for your help, please let me know if I can provide any more information.

    EDIT - We are using Dropbox to Sync our files, so we do not have the same file paths as we would have on a server.

  2. #2
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    UK - Wiltshire
    In Excel you could get the current path from
    CurDir() returns C:\Users\[username]\Documents
    Not sure if this helps though?

  3. #3
    DomSza is offline Novice
    Windows 10 Access 2016
    Join Date
    Jun 2016
    I have found a solution to this, in case anyone stumbles across this thread.

    Instead of finding some technical way of doing this, I'm just moving the dropbox folder on each PC to the same location. Every user's PC will have the path C:\Dropbox\Database.accdb.

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

Similar Threads

  1. Excel refresh blocks Access data entry
    By simaonobrega in forum Import/Export Data
    Replies: 4
    Last Post: 06-30-2017, 11:01 AM
  2. Replies: 1
    Last Post: 06-28-2016, 06:43 AM
  3. Replies: 0
    Last Post: 09-18-2012, 04:15 AM
  4. Replies: 4
    Last Post: 12-16-2010, 05:29 AM
  5. Replies: 2
    Last Post: 04-22-2010, 10:40 AM

Tags for this Thread

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