472,799 Members | 1,588 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,799 software developers and data experts.

Simple question???

I just want to know how many records an MS Access database can contain ???

Thank you,

Nov 12 '05 #1
2 1948
"Alain Pelletier" <ni******@nb.aibn.com> wrote in message
I just want to know how many records an MS Access database can contain ???

There is no limit on the record number, only on the *size* of tables and files.
Depending on how many bytes are used per record, you would hit the maximum size at
differing quantities of records.

Technically; Access is not the database. It is the program used to interface with
the database. Out of the box, Access uses either the Jet database engine or the
MSDE. These both have size limitations based on bytes, not record count. In Access
97 the limit of a file is 1GB. In newer versions it is 2 GB. One can theoretically
spread data among multiple linked files and circumvent the file size limitations, but
in general practice, working with that much data in Jet tables is not recommended.

If you use Access against other database engines (SQL Server, Oracle, etc.), then you
have only the limits that those products provide.
Nov 12 '05 #2
> I just want to know how many records an MS Access database can contain ???

There is no definitive answer to you question. The number of records
an Access database can contain is limited by several factors,

- the version of Access/Jet (i.e. an Access 97/Jet 3.x database cannot
exceed 1GB)
- the definition of a record (i.e. an integer data type requires only
two bytes of storage, while a long integer data type requires four
- the quantity and complexity of objects (tables, queries, forms,
reports, macros, modules) in the database
- whether the database is in a compacted state (a database usually
requires less storage space when compacted)

Without a closer examination of the application requirements, it is
impossible to specify how many records a database will hold.

Gordon Rogers
MICO, Inc.

"It's not worth getting into the bullshit to find out what the bull
--Captain Beefheart
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: Patchwork | last post by:
Hi Everyone, Please take a look at the following (simple and fun) program: //////////////////////////////////////////////////////////////////////////// ///////////// // Monster Munch, example...
by: Proteus | last post by:
Any help appreciated on a small perl project I need to write for educator/teaching purposes. I have not programmed perl for some time, need to get up to speed, maybe some kind souls hrere will help...
by: Raskolnikow | last post by:
Hi! I have a very simple problem with itoa() or the localtime(...). Sorry, if it is too simple, I don't have a proper example. Please have a look at the comments. struct tm *systime; time_t...
by: Peter | last post by:
Hello Thanks for reviewing my question. I would like to know how can I programmatically select a node Thanks in Advanc Peter
by: abcd | last post by:
I am trying to set up client machine and investigatging which .net components are missing to run aspx page. I have a simple aspx page which just has "hello world" printed.... When I request...
by: dba_222 | last post by:
Dear Experts, Ok, I hate to ask such a seemingly dumb question, but I've already spent far too much time on this. More that I would care to admit. In Sql server, how do I simply change a...
by: Giancarlo Berenz | last post by:
Hi: Recently i write this code: class Simple { private: int value; public: int GiveMeARandom(void);
by: galiorenye | last post by:
Hi, Given this code: A** ppA = new A*; A *pA = NULL; for(int i = 0; i < 10; ++i) { pA = ppA; //do something with pA
by: Phillip Taylor | last post by:
Hi guys, I'm looking to develop a simple web service in VB.NET but I'm having some trivial issues. In Visual Studio I create a web services project and change the asmx.vb file to this: Imports...
by: Chris M. Thomasson | last post by:
I use the following technique in all of my C++ projects; here is the example code with error checking omitted for brevity: _________________________________________________________________ /*...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.