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 11531
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: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
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...
| |