I am trying to use external files but keep getting this error
Access to external file "C:\magusdb\dxs3.txt" is denied by server administrator.

I have modified firebird.conf External file paths/directories section to include
ExternalFileAccess = Restrict C:\magusdb
also separately tried ExternalFileAccess = Full
I stopped & restarted the server in each case.

I use this to create & import the external file

CREATE TABLE IMPORT_DXS external file 'C:\MagusDB\dxs3.txt'
(
IDXSNo CHAR(10),
ABS_NO CHAR(10),
DB CHAR(10),
DW CHAR(10),
VALUE1 CHAR(10),
USED CHAR(10),
space CHAR(10),
UOP CHAR(10)
);

The table gets created ok but as soon as I try & read the data I get the error.

I have formatted dxs3.txt to fixed-format text.

I have searched through previous messages on the problem but have not found anything other than what I have tried.

Can anyone suggest where I am going wrong or what else I can try, thanks for any help.

Windows XP SP3 firebird 2.5.1

Jack