Subject Re: [ib-support] DB Design Access - Firebird
Author Adrian Roman
>I've got an older datalogging application which is based on MS Access and
>I'd like to port it to Firebird 1.02.

This is the right choice! By the way, do you know that Jet Engine is unable
to reuse the free blocks inside the database unless all clients close the
database? If everything else works like this in Jet, no wonder it works like
hell.

>As far as I know Firebird doesn't support links to tables in seperate .gbd
>files
>How can I port such a design to Firebird?

Why? The limitations in MS Access doesn't apply to Firebird. You can use a
database formed from multiple files, and never reach the size limit.

>I can put all tables for all years into one database, but how can I be sure
>not to reach the file size maximum ?
>(maximum is 4GB on NTFS, isn't it ?)

You can be sure. A Firebird database can use multiple files.


Adrian Roman