You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.

Forum Discussion

Stanners's avatar
Stanners
New member | Level 2
12 months ago

Database reference links don't work for other people accessing them

I have an access database and a set of excel files.  The database links to the Excel files for data to feed the database.  The output from the database is via an Excel file that links back to the dat...
Desktop
Microsoft Office
Share
Sync
Stanners's avatar
Stanners
New member | Level 2

So in my case

 

 

I swap C:\Users\petes\ 

for %HOMEPATH%

 

This doesn't work \\%HOMEPATH%\Daimon Barber Dropbox\A1 DB SharedFolder

 

Is this the correct format?

 

 

for

Stanners's avatar
Stanners
New member | Level 2
12 months ago

Here is my link from the Excel file

DataFormat.Error: 'C:\Users\louis\Daimon Barber Dropbox\A1 DB SharedFolder\Costing_Pricing\Product Costs\BOMDatabase\BackOrders.xlsx' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
Details:
Stock_V1.accdb

 

C:\Users\louis on Louis

C:\Users\petes on my computer

How do I use the %HOMEPATH% to replace these

 

 

About Create, upload, and share

Find help to solve issues with creating, uploading, and sharing files and folders in Dropbox. Get support and advice from the Dropbox Community.

Need more support

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!