Thank you, but MS Access don't support the quote syntax. I think the
only solution is to rename the table.

Ricardo


--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

>
> > I have a table named Time and I'm trying to create a query that

runs

> > both in Access and Firebird. The Access query runs if I enclose

the

> > table name within brackets ([Time]). But Firebird doesn't accept

this

> > syntax. I have to put the table name within quotes ("Time"). Is

there

> > a way I can get the query working in both databases?
>
> You might want to try "Time" with Access as well. MS Access and
> MS SQL Server are the only database engines that support the
> non-standard bracket syntax.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL

& MS SQL

> Server
> Upscene Productions
> http://www.upscene.com