File size - 2 gigabytes minus the space needed for system objects Number of objects in a database - 32,768 Modules (including forms and reports with the HasModule property set to True) - 1,000 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 Table
Number of characters in a table name - 64 Number of characters in a field name - 64 Number of fields in a table - 255 Number of open tables - 2048; the actual number may be less because of tables opened internally by Microsoft Access Table size - 2 gigabyte minus the space needed for the system objects Number of characters in a Text field - 255 Number of characters in a Memo field - 65,535 when entering data through the user interface;
1 gigabyte of character storage when entering data programmatically Size of an OLE Object field - 1 gigabyte Number of indexes in a table - 32 Number of fields in an index - 10 Number of characters in a validation message - 255 Number of characters in a validation rule - 2,048 Number of characters in a table or field description - 255 Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property of the fields is set to Yes - 4,000 Number of characters in a field property setting - 255 Query Number of enforced relationships - 32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships Number of tables in a query - 32 Number of fields in a recordset - 255 Recordset size -1 gigabyte Sort limit - 255 characters in one or more fields Number of levels of nested queries - 50 Number of characters in a cell in the query design grid - 1,024 Number of characters for a parameter in a parameter query - 255 Number of ANDs in a WHERE or HAVING clause - 99 Number of characters in an SQL statement approximately - 64,000 Form and report Number of characters in a label - 2,048 Number of characters in a text box - 65,535 Form or report width - 22 in. (55.87 cm) Section height - 22 in. (55.87 cm) Height of all sections plus section headers - 200 in. (508 cm) Number of levels of nested forms or reports - 7 Number of fields or expressions you can sort or group on in a report - 10 Number of headers and footers in a report - 1 report header/footer; 1 page header/footer; 10 group headers/footers Number of printed pages in a report - 65,536 Number of controls and sections you can add over the lifetime of the form or report - 754 Number of characters in an SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control (both .mdb and .adp) - 32,750 Macro
Number of actions in a macro - 999 Number of characters in a condition - 255 Number of characters in a comment - 255 Number of characters in an action argument - 255
4 11536
Wow, what a useful post.
I have already been hit by the number of indicies on a table, and the number of fields in a table but this one was new to me
Number of concurrent users - 255
In the late 90's I wrote a system for 400 users. Never had any problem, as I doubt more than 50 odd where logged on at anyone time, but never realised there was a 255 limit.
This article needs printing off and filed for future reference, thanks
Is there a way of changing the length of a form beyond the 22in limit?
Is there a way of changing the length of a form beyond the 22in limit?
Why would you want to? It would be pretty unmanagable.
The answer, of course, is no! And as Mary pointed out, even if you could, it would be very user un-friendly! If you're running into this kind of real esatate problems you need to expand horizontally, using Tabbed Pages! They really are great for things other than just subforms!
Check out Using Tabbed Pages on a Form
Linq ;0)> Sign in to post your reply or Sign up for a free account.
Similar topics
by: Xah Lee |
last post by:
Microsoft Hatred, FAQ
Xah Lee, 20020518
Question: U.S. Judges are not morons, and quite a few others are
not morons. They find MS guilty, so it must be true.
Answer: so did the German...
|
by: robin9876 |
last post by:
In an Access 97 (and 2000) database that has linked tables to Oracle
which is showing some fields as text when they are numbers in Oracle.
In Oracle they are specified to a size e.g. Number(38)....
|
by: pietlinden |
last post by:
I almost feel stupid posting this, but maybe someone else understands
what's going on here.
I am importing a delimited text file, and have saved an import
specification so that for the user the...
|
by: Andy Dingley |
last post by:
http://www.microsoft.com/mac/products/internetexplorer/internetexplorer.aspx?pid=internetexplorer
Microsoft will end support for Internet Explorer for Mac on December
31st, 2005, and will provide...
|
by: Stuart Golodetz |
last post by:
Hi all,
Just wondering whether there's any reason why exception specifications are
enforced at runtime, rather than at compile-time like in Java? (This was
prompted by reading an article on...
|
by: chimambo |
last post by:
I have 2 problems:
1. I want to import a single text file into an access table using a
Macro. I am however getting an error that I need to put a
specification name argument. What does this mean?...
|
by: Ioannis Vranos |
last post by:
Perhaps a mechanism can be introduced in the C++0x/1x standard,
something simple like defining a function as:
void somefunc(void) throw()
{
// ...
}
|
by: Premal |
last post by:
Hi ALL,
Is there any place from where I can download C++ language
specifications? I am looking for C++ specifications means how function
call works, how memory is allocated etc... I am searching...
|
by: Mimi |
last post by:
In Access 2007, I have successfully imported a text file with fixed width
fields. However the import did not correctly interpret a date. In the text
file the date field had no delimiter, was just...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
| |