xbase ODBC with DBF. Write permission on Folder?
Posted: Tue 07 Jan 2020 08:12
Hi all
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!?
Thanks René
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!?
Thanks René