Access 97's capacity...

[jeppe]

How much datas Access 97 can records to database?

I have 6 tables and these are similar. In the table is three fields. These are ID, barcode and scandate.

How much data records Access can save to per table? about...I will be about 1000-3000 data records to field per table in day.

Is possible do a real time backup copy of database? Like that Access doing a backup archive every day and cleans old fields same time from tables. I have Loops which adds a barcodes from serial ports to tables all times...

 

[Studentos]

Specifications F1

(for XP):

Table size 2 gigabyte minus the space needed for the system objects

If you need to store 3000 records per day and make a realtime backup you should use SQL server such as MS SQL

 

[bvan]

Correction: Access97 has a limit of 1 gigabyte, not 2 gigabytes.