Skip to main content
Solved

Lettered Path vs UNC Path and Access Database

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.

View original
Did this help you find an answer to your question?

2 replies

hkingsbury
Celebrity
Forum|alt.badge.img+51
  • hkingsburyCelebrity
  • Celebrity
  • 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
  • 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.

Reply


Helpful Members This Week

Community Stats

31,009
Posts
117,523
Replies
38,788
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.