Hi Terry,

> I'm trying to find a utility (that works) for converting Access97 or
> Access2000 mdb files into FB1.5 fdbs.
>
> The sql2gdb utility seems to work converting to FB1.03, but loses almost
> everything, especially FK constraints (except the data and indeces) when
> converting to FB1.5.
>
> I also have the trial version of dbworkbench, but that gives me a
> 'Operation not supported' if I try to move an ODBC (mdb) datasource to FB.

What about ADO? Either way - I would be interested in a
copy of your database, to check where things go wrong.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com