--- In firebird-support@yahoogroups.com, "robertgilland"
<robert_gilland@...> wrote:

>
> What is wrong with this statement:
>
> CREATE TABLE "EXT_PLUSALES"
> EXTERNAL FILE 'C:\PLUSALES.ASC'
> ( STOREID VARCHAR(10) NOT NULL,
> SALESDATE TIMESTAMP NOT NULL,
> PLU VARCHAR(14) NOT NULL,
> QUANTITYSOLD FLOAT,
> COSTEXGST FLOAT,
> COSTINCGST FLOAT,
> SALESEXGST FLOAT,
> SALESINCGST FLOAT,
> PRIMARY KEY ( STOREID, SALESDATE, PLU ));
>
> I get this message:
>
> ISC ERROR CODE:335544831
>
> ISC ERROR MESSAGE:
> Access to external file "C:\PLUSALES.ASC" is denied by server
> administrator

You need to change Firebird.conf (ExternalFileAccess), the conf file
documents how this works. The service needs to restart to read in the
new values (possibly not for classic, but to be on the safe side).

Second, the user Firebird is running as (normally LocalSystem) must
have read/write file system access to this file.

Adam