Limitations of Access 97

[Guest]

Hi,

i have very general question regarding capability:

a) To store # of records OR in MB
b) If we link other tables which are on their full capasities to fresh data
base how it would effect on efficiency?
c) How it will be beneficial if we upgrade then how many more records can be
saved?

I know it all depends on number of fields of records but I just need an idea
- thanks

Thanks for help.

Amir

 

[Douglas J. Steele]

There's no limit based on the number of records that can be stored. The
limit is on the size of the MDB (or MDE) file. In Access 97, the MDB file
cannot exceed 1 Gb. (The limit is 2 Gb in newer versions of Access, but that
doesn't necessarily equate to a doubling of capacity, since the newer
versions of Access use Unicode, which requires 2 bytes for a single text
character, as opposed to the 1 byte in Access 97)

Linking to tables in other databases will be less efficient (plus you cannot
enforce referential integrity through the Jet Engine if the tables aren't in
the same database).

 

[Guest]

It would take a large number of records for your database to be full.
Is it fully compacted?
If it has never been compacted, this could be the issue.
Try using 'tools', 'database utilites', 'compact and repair'.
The size limtation could also be on the folder in which the database is
stored, rather than the database itself.

Luck, Mike