> 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