Access 97....Record threshold...is there such a thing? 1

[JoseQuiervo]

I was curious as to how many records an Access 97 table can handle before it becomes problematic?

 

[psemianonymous]

Access 97 db's can hold 1GB of data. I don't think the size of the mdb file is as big of a problem as how much load the file server is able to handle. What I'm saying is that you can use a 900MB file with no problems so long as you're the only user. But you may not be able to work on a 10MB MDB if you're sharing it with 100 other people over the network. In this, size *does* affect performance, but it's not the *only* factor that affects performance.

Access will generate an error message once you reach the 1GB limit and will refuse further entry until you get it below the limit. So keep it well under the limit, so you never have to worry about it accidentally bloating over 1GB.

 

[GKProgrammer]

Hi Jose,

FYI, if you go to your help file and click the Index tab and type in size limits you can access a full list of specifications on all Access objects (ie. Tables, queries, forms etc)

Regards,
gkprogrammer

 

[Hap007]

Dear gkprogrammer

Good post, star to you:

Here is the Access 97 Help Info:
Database (.mdb) file size 1 gigabyte.
However, because your database can include linked tables in other files, its total size is limited only by available storage capacity.

Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to True) 1024

Number of characters in an object name 64

Number of characters in a password 14

Number of characters in a user name or group name 20

Number of concurrent users 255

Hap


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

-
Specializing in Access based Add-on Solutions for the Developer