Hello all,
I've got an older datalogging application which is based on MS Access and
I'd like to port it to Firebird 1.02.
Working on Windows NT 4.0 Sp6a with NTFS.

The Access-DB is designed as follows:

For each year there is a .mdb file with tables where logged data is stored
(2002.mdb, 2003.mdb ...)
and one frontend.mdb which has links to all tables in 2002.mdb, 2003.mdb ...
actually up to 2009.mdb.
Using seperate .mdb files for each year I could be sure to not reach the
file size maximum.

There was only one connection made to the frontend.mdb and I was able to
read data for two or more years without opening another connection to a year
.mdb file.

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

Thanks for any help,
Ralf.


MEP Kutsch GmbH & Co. KG
Flaßkuhle 1
58452 Witten
Tel.: 02302 28262-30
Fax.: 02302 28262-99

mailto:ralf.erdmann@...

http://www.mep.de