Skip to main content
Solved

Lettered Path vs UNC Path and Access Database

  • July 18, 2023
  • 2 replies
  • 224 views
vxn43
Supporter
Forum|alt.badge.img+18

I have a workspace where the Reader reads an Access database using a lettered drive path (K:\\projects\\databases\\access.mdb) The Writer writes to the same database using the same lettered drive path. When I publish this workspace to FME Flow without uploading/selecting files, the Database Path under Published Parameters is empty.

​

But, when I change the database paths in my workspace to a UNC path (\\\\gisserver1\\projects\\databases\\access.mdb), I publish the workspace (without uploading/selecting files) and I see the UNC path to the Access Database populated in Published Parameters - Database Path.

​

If my workspace reads from a lettered drive path and the database is Microsoft Access, when I publish the workspace, do I need to upload/select files? This would upload the Access database to FME Server.

Best answer by hkingsbury

If you upload a file as part of publishing to FME Flow (Server) you are making a local copy of that data. So if you update it, you are not updating the data on the shared drive.

 

In terms of UNC vs Lettered drives, my preference (and advice) is to always go down the UNC path. Each machine could have a different location mapped to a different letter, if you're using letters, it can become very complicated.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+63
  • hkingsburyCelebrity
  • Celebrity
  • 1632 replies
  • Best Answer
  • July 18, 2023

If you upload a file as part of publishing to FME Flow (Server) you are making a local copy of that data. So if you update it, you are not updating the data on the shared drive.

 

In terms of UNC vs Lettered drives, my preference (and advice) is to always go down the UNC path. Each machine could have a different location mapped to a different letter, if you're using letters, it can become very complicated.

vxn43
Supporter
Forum|alt.badge.img+18
  • vxn43Supporter
  • Author
  • Supporter
  • 48 replies
  • July 18, 2023

Thank you, this is the answer I was hoping for. Ensuring that you use UNC paths in your workbenches prior to publication to FME Flow is the most efficient workflow.

Community Stats

32,102
Posts
121,897
Replies
39,750
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.