Create tables "linkes" using a relative path

[skydivetom]

Hello:



I need some assistance with "linking" tables using, e.g., a relative path.

Quick background:
- Our team is working in a distributed/remote environment.
- That is, we do NOT have access to a shared/common drive (as it would be available in a brick & mortar building).
- Instead, we use SharePoint to access common files.

Common Files on SharePoint:
Now, when linking tables (backend) to a database front-end (forms, queries), I am selecting the BROWSE option to locate the file via SharePoint.

In the "Get External Data - Access Database" dialogue box, I ultimately choose the file from the following location:
C:\Users\username\CompanyName\SourceTables_be.accd b

... where username = "MyName"

Hence, any other team member who opens the frontend will NOT be able to bring up any tables, queries, forms, etc.

Here's what I tried:
- I tried changing "C:\Users\username\CompanyName\SourceTables_be.acc db" to "\\SourceTables_be.accdb" but that did NOT work.

My question:
- How can I connect to the tables via a relative path so that any user (who opens the file via SharePoint) can access the source tables?
- In the event I can't use relative paths for table linking, does anyone know of some, e.g., VBA solution that would allow for a solution?

[Micron]

Connect to the SP server? The server has it's own path which might look something like
\\sharepoint\CompanyName\Level1\Level2\Level3_and_ so_on\

There would be no "C" or any other drive letter that should be used AFAIK.

[skydivetom]

Micron:

Hmh, that sounds like a promising idea.

Here's what I've done:
- Open up SharePoint (browser) and navigate to the ACCDB file.
- Click on "Copy Link"... which created this huge link such as:

https://CompanyName.sharepoint.us/.....1&web=1&e=x8yz

I then pasted that link into the Access dialogue box. Unfortunately, it returned an error that I can't use a file located on the internet. See attached snapshot.

Any thoughts on how I need to change the SharePoint URL? Again, we work remotely so there's no common drive available to us.

[June7]

So where is the SharePoint file?

Does this help https://www.access-programmers.co.uk...ectory.308488/

[Micron]

That is not what I showed you. I guess I should have elaborated. That is the URL (web path) to the sp server. You need the UNC path. If you can map a drive letter to it, that path will show up in the properties of the drive letter. Same as if you have multiple drives on a network server, and D is mapped to one drive, F to another, M to another and so on - different drives to the same server. However, sometimes you can't use those drive letters, and this is one of those times. Using the UNC path to the server is how you get to the sp server by its real name. C or D is just a label, kind of like my username here. Obviously my mother didn't name me Micron.
HTH.

[skydivetom]

Micron -- thank you for the clarification. I'll further research the UNC path. I'll keep you posted.