xbase ODBC with DBF. Write permission on Folder?
I'm using the trial version of the xBASE ODBC driver to read data from VisualFoxPro (.dbf). I only need to read data!
I have a working test setup on a Windows 2012 server, 64-bit where I use an O365 64-bit MS Access database with linked tables (dbf-files). Same works for pass-through queries. Everything is on that server. Same setup works when the data files are on a network share with full permission on the folder where the data files are stored.
As soon as I try to access data on a folder where I only have read/execute rights, it doesn't work anymore and it looks like it requires write access. Granting write access to that folder confirmed the assumption. However, I would like to know if there is really write permission required or can this be prevented!?