Does anyone have knowledge of the limits of an Access database, both size
(i.e. in MB)and/or number of records? Also is there a difference between 97
and 2000?
All for now.
Dean

Look in Access Online Help. The answers to these questions are there.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Thomas, Dean" <Dean.Thomas@u...>
Subject: [access_asp] Limits of Access DB


: Does anyone have knowledge of the limits of an Access database, both size
: (i.e. in MB)and/or number of records? Also is there a difference between
97
: and 2000?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ken,
In the Online help I found a limit for records of 2,147,483,647 (long
integer constraint if autonumber counter is used). They mention a size limit
as well but I could not find this. I was hoping for some real-life
experience.
All for now.
Dean

-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Sunday, March 09, 2003 9:25 PM
To: Access ASP
Subject: [access_asp] Re: Limits of Access DB


Look in Access Online Help. The answers to these questions are there.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Thomas, Dean" <Dean.Thomas@u...>
Subject: [access_asp] Limits of Access DB


: Does anyone have knowledge of the limits of an Access database, both size
: (i.e. in MB)and/or number of records? Also is there a difference between
97
: and 2000?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

1.2G total for the database, total records cannot exceed a signed long 
integer positive rail (2^31), whichever limit get hit first (usually the 
1.2G limit).

Skip