At 10:55 AM 5/02/2004 +0100, you wrote:

>Hi all
>
>I've this DDL
>
>CREATE TABLE EXT_TABLE EXTERNAL FILE 'C:\DBFB\External\file.txt'
>(
> FNAME CHAR(10),
> LNAME CHAR(20)
>)
>
>
>When I'm execute command not error occurred, but when I want commit
>transaction following error appear
>
>Cannot commit transaction:
>Unsuccessful execution caused by a system error that precludes
>successful execution of subsequent statements.
>Access to external file "file.txt" is denied by server administrator.
>
>
>I'm a user of "Administrators" group on WinXP

That's nothing to do with your problem - you don't need to be a member of
"Administrators", only the server does.

>FB 1.5 RC8

Your problem is that the server installs with access to external files
disabled by default. Shut down the server, go to firebird.conf and find
the parameter ExternalFileAccess. Uncomment the parameter, change it from
NONE to RESTRICT and enter a path to a root-path where the server is
allowed to access external files. If you want it to be able to access more
than one root-path, separate multiple root-paths using commas.

For more documentation, see the release notes. I wish people would READ
these darned things!!

/heLen