maxilmum limit of records and fields filled in msaccess...

S

suresh

what is the maxilmum limit of records and fields filled in msaccess?
how many files can be opened and work with link simultaneously?
is there any sql support for this?
 
J

John Vinson

what is the maxilmum limit of records and fields filled in msaccess?
how many files can be opened and work with link simultaneously?
is there any sql support for this?
Click to expand...

Take a look at "Specifications" in the online help for these and other
limits. 2 GByte in any one .mdb or .adp file; no express limit on
number of records (in practice 20,000,000 is about the biggest
production Access table I know of); 255 fields, which is far more than
should ever be needed; 2000 characters (4000 Unicode bytes) actually
occupied in any single record.

John W. Vinson[MVP]
 
R

Randy Balbuena

Suresh said:
what is the maxilmum limit of records and fields filled in msaccess?
how many files can be opened and work with link simultaneously?
is there any sql support for this?
Click to expand...


ACCESS DATABASE LIMITS
Specifications for Microsoft Access 97 / 2000 / 2002 / 2003


GENERAL
Maximum MDB size: 2 GB*
Maximum table size: 2 GB**

Number of characters in a record: 4,000***

(* 2 GB for Access 2000/2002/2003, 1 GB for Access 97. Please note that is a
"nominal" size, since system objects are included)
(** 2 GB for Access 2000/2002/2003, 1 GB for Access 97. However, because
your database can include linked tables in other files, its total size is
limited only by available storage capacity. Please note that this number is
a "nominal" size, since system objects are included)
(*** 2,000 for Access 97/2000/2002. 4,000 for Access 2003 when the
"UnicodeCompression" property of the fields is set to "Yes." For either of
the versions: the number of characters excludes Memo fields & OLE Objects
fields)


FIELD CONTENT
Number of characters in a Text field: 255
Number of characters in a Memo field: 65,535*
Size of an OLE Object field: 1 GB

(* 65,535 when entering data through the user interface, but 1 GB when
entering data programmatically.)


STRUCTURE DEFINITION
Number of objects in a database: 32,768
Number of characters in a table name: 64
Number of characters in a table description: 255
Number of fields in a table: 255
Number of characters in a field name: 64
Number of characters in a field description: 255
Number of characters in a field property setting: 255
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


You can find all of the database and project specifications by clicking
"Microsoft Access Help" on the Help menu in Microsoft Access, typing
"specifications" in the Office Assistant, and then clicking "Search" to view
the "Access Specifications" topic or check the following link for the
specifications on the latest version of Access:
http://office.microsoft.com/en-us/assistance/HP051868081033.aspx
 
R

Randy Balbuena

Randy said:
ACCESS DATABASE LIMITS
Specifications for Microsoft Access 97 / 2000 / 2002 / 2003


GENERAL
Maximum MDB size: 2 GB*
Maximum table size: 2 GB**

Number of characters in a record: 4,000***

(* 2 GB for Access 2000/2002/2003, 1 GB for Access 97. Please note that is
a "nominal" size, since system objects are included)
(** 2 GB for Access 2000/2002/2003, 1 GB for Access 97. However, because
your database can include linked tables in other files, its total size is
limited only by available storage capacity. Please note that this number
is a "nominal" size, since system objects are included)
Click to expand...

Correcting myself, the last paragraph (**) should read:
(** 2 GB for Access 2002/2003, 1 GB for Access 97/2000. Howe...
 
S

suresh

thanks a lot, iam new in ms acess and i want to know more about ms acess

how can i create a file and table '
what is the master file?
what is transaction file ?
what are the input and output files and how ca i create it;
what are the keys are (primary ,foreign etc ) used to link the files
 
R

Randy Balbuena

Suresh said:
thanks a lot, iam new in ms acess and i want to know more about ms acess

how can i create a file and table '
what is the master file?
what is transaction file ?
what are the input and output files and how ca i create it;
what are the keys are (primary ,foreign etc ) used to link the files
Click to expand...

Suresh, It sounds like you will need a beginners study guide oriented book,
so you can understand what Access does, its terminology and concepts, and
steps to accomplish its function/use. If you are migrating from another
database software/solution, you should be able to find a book oriented to
that topic.

Also it may be good idea to let us know your current database software, to
help you adapt into Access and avoid confusion. I'm sure some else will post
either links to good tutorials, recommend books, or with their experience,
help you with the migration.
 
Top