Sorry Helen, the utility I am using for conversion is sql2gdb. I am
using IBAccess as frontend to Firebird.

Thanks

--- In ib-support@y..., "sanjayamatya" <sanjayamatya@y...> wrote:
> 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/
> > _______________________________________________________