Hi

I would appreciate it if someone can help me please. . .

I am trying to create a external table, the text file is copied in the same
location as my database.

This is the syntax I am using to create the table :

CREATE TABLE CODES_EXTERNAL EXTERNAL FILE 'DIAGNOSIS.txt'
(CODE CHAR(6), DESC CHAR(25), EOL_FIELD char(2));

If I run the script, I get the following error:

Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Access to external file "DIAGNOSIS.TXT" is denied by server administrator.

The funny thing is, I am the server administrator and no security has been
set up for this specific file.
OS : WinXP Pro
FB 1.52

If I add the path to the textfile in the create table statement, the same
error occures.

I guess there is something else causing this.

Regards
Louis