jjacksn
asked on
Maximum Number of Records?
What is the limit on the number of records in an access database?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Jim Horn
Oops, GB instead of MB.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you trying to calculate max number of records for a table within a database?
Add max size of each field in bytes for max recordsize in bytes.
Divide into 1 billion or 2 billion, and you will get a rough estimate.
Add max size of each field in bytes for max recordsize in bytes.
Divide into 1 billion or 2 billion, and you will get a rough estimate.
BTW my excerpt is from A2K Help
Thanks, glad I could help.