I created a split DB that is used throughout our small office. A couple of my coworkers need to move some of data to Excel from the tables in the back end that is housed on a shared volume inside of our LAN. First I setup the connections Using the basic "From Access" wizard, but that tool appears to need exclusive access and prevents anyone else from opening the database so long as the connected Excel file is open. Next, I used the "From Other Sources" wizards, and set up a custom query, that doesn't prevent other users from using the database, but it only allows the computer that the connection was set up on to refresh the Excel table, because the connection wizard insists on creating a drive letter, that is unique to that computer. Looking for any help setting up these connections that A. Allow other users to use the database while the Excel file is open, and B. allow multiple Excel users to refresh data using the same connection setup. I have some, but limited VBA knowledge.
Last edited: