The utility I am using is IBAccess. I tried various ways to access
tables, but couldn't. I found that I am not allowed even to create
the table or insert data.

When I try to insert data into imported table from Access: get the
error: Table unknown.

When trying to create a new table into imported database, get the
error: Token unknown.

Thanks

--- In ib-support@y..., Helen Borrie <helebor@t...> wrote:
> At 10:03 PM 12-04-02 +0000, you wrote:
> >A simple database got converted to gdb fine. But could access only
> >one of the tables using commaand "select * from tblAAA". While
trying
> >to execute this command for other tables produced following error:
> >
> >Dynamic SQL Error
> >- SQL Error code = -204
> >- Table Unknown
> >- tblAAA
> >- At line 1, column 15
> >
> >Ideas?
>
> The utility you used to make the conversion may have created case-
sensitive
> identifiers (object names). This will be so if it created them
with
> double-quoted delimiters. For example, if it created this table
with
> CREATE TABLE "TBLAAA" then the name of the table is TBLAAA,
not "tblAAA".
>
> From another list I note that you used the sql2gdb converter. I
suspect
> that tool probably applies quoted identifiers to Access data,
because
> Access permits "illegal" characters - which, in Firebird/InterBase
6.x is
> not permitted unless the quote delimiters are used.
>
> cheers,
> Helen
>
>
> All for Open and Open for All
> Firebird Open SQL Database · http://firebirdsql.org ·
> http://users.tpg.com.au/helebor/
> _______________________________________________________