what is the virtual capacity of Access 97?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A solution using Runtime Access97 will be able to manage how much data? Is
there a limit in terms of capacity and performance?

We are getting different answers on the subject, but everyone is confirming
a limit.
 
Hi Faph,

An A97 file has a limit of 1GB. Later versions have 2GB limit. Note that
this is a physical file size limitations, not number of records. Even then,
there are ways around the file size limitation through the use of linked
tables. You should also check with the help file in Access and type
"Specifications" for more information on limitations.


HTH,
Immanuel Sibero
 
A solution using Runtime Access97 will be able to manage how much data? Is
there a limit in terms of capacity and performance?

We are getting different answers on the subject, but everyone is
confirming
a limit.
Click to expand...

The limit is not the number of records, but in fact the file size. So, you
can have a maxim file size of 1 gig.

Assuming that you have a typical mailing list, or customer list, and lets
assume that each customer is 80 characters. Thus, you get:

1,000,000,000 / 80 = 12,500,000

So, you get 12 million records. If your average record size is 40
characters, then you get 24 million records. So, the number of records is
based on the file size limit, and the size of each record will determine how
many records you get.

As for capacity and performance, there are MANY factors to consider here.
For example, are we talking about a single user application with no network?
Or, are we talking about a multi-user setup where the data file is shared on
a network?

Obviously, when the data is on the local hard disk, you can work with much
larger data sets then a slow network for example...
 
Back
Top