Hi,

At April 30, 2003, 06:19, Erdmann, Ralf wrote:

> 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?

Put every thing in one database file. By the way, what is the average
size of your Access files?

> 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 ?)

On Windows, Firebird 1.0 support 64-bit file I/O. So, the 4GB limit
no longer exists, the limit is whatever Windows can support,
apparently 16TeraByte minus 64KB, but the file can't be larger than
the volume or partition that it is on. So, if the volume is 160GB,
the file size limit should be almost 160GB on that volume.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)