TAMANHO MAXIMO DE UM MDB ?
Qual o tamanho maximo de um mdb sendo que uso 97 e 2003 e 2007?
Obrigado
Obrigado
Segundo o site do macoratti:
8-) Quais as limitações de um banco de dados da versão MS Access 97 - Versão 3.5X ?
Tamanho máximo do arquivo mdb => 1GB
Número máximo de objeto em um banco de dados => 32768
Comprimento máximo para o nome de um objeto => 64
Comprimento da Senha => 14
Comprimento máximo para nomes de usuários e grupos => 20
Número máximo de usuários conectados ao banco de dadaos => 255
Comprimento máximo do registro => 2048
Número máximo de campos na tabela => 255
Número máximo de transações aninhadas => 7
em:
http://www.macoratti.net/daoback.htm
8-) Quais as limitações de um banco de dados da versão MS Access 97 - Versão 3.5X ?
Tamanho máximo do arquivo mdb => 1GB
Número máximo de objeto em um banco de dados => 32768
Comprimento máximo para o nome de um objeto => 64
Comprimento da Senha => 14
Comprimento máximo para nomes de usuários e grupos => 20
Número máximo de usuários conectados ao banco de dadaos => 255
Comprimento máximo do registro => 2048
Número máximo de campos na tabela => 255
Número máximo de transações aninhadas => 7
em:
http://www.macoratti.net/daoback.htm
E NO ACCESS 2007 COMO FICA é O MESMO TAMANHO??
OBRIGADO
OBRIGADO
Conforme o site: http://blogs.msdn.com/b/access/archive/2006/06/05/access-2007-limits.aspx
This is a quick post to lay out the limits in Access 2007 and make a little clearer how the application works and how it scales. The first table below shows the limits of the database engine itself.
Access Database Limits
Access database (*.mdb or *.accdb) file size
2 gigabytes, including all objects in the database (data, forms, reports, indices, macros, modules, etc.)
Total number of concurrent users
255. Note that the practical limit will likely be lower than this based on database design.
Table Limits
Number of tables
This is governed by a limit on the number of objects in the database, which includes tables, forms, reports, queries, etc. The limit on DB objects is 32,768.
Table size
2 gigabytes, less the space needed for system objects
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 Note that this includes internal tables opened by Access.
Number of characters in a text field
255
Number of characters in a memo field
65,535 when text is entered through the UI
1 gigabyte if text is entered programmatically
Size of an OLE Object field
1 gigabyte
Number of indexes on a table
32
Number of fields in an index or primary key
10
Number of characters in a validation rule
2048
Number of characters in a validation message
255
Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property is set to Yes.
4,000
Number of characters in a field property setting
255
In addition, Access applications themselves have a number of limits, including:
Access Database Limits
Number of objects in a database
32,768 Note that this includes tables, forms, reports, queries, macros, modules, indices, and internal objects used by Access.
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
Table Limits
Number of open tables
2048 Note that this includes linked tables as well as local ones, and that the number may be somewhat lower due to internal tables opened by Access.
Query Limits
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 returned by a query
255
Maximum 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 in a parameter in a parameterized query
255
Number of ANDs in a WHERE or HAVING clause
99
Number of characters in a SQL statement
Approx 64,000
Form & Report Limits
Number of characters in a label
2,048
Number of characters in a text box
65,535
Form or report width
22 inches (55.87cm)
Section height
22 inches (55.87cm)
Height of all sections, plus section headers in design view.
200 inches (508 cm) Note an actual report can be arbitrarily long once the data has expanded.
Number of levels of nested forms or reports
7
Number of fields or expressions that can be sorted or grouped in a report
10
Number of headers or footers in a report
1 report header / footer
1 page header / footer
10 section headers / footers
Number of printed pages in a report
65.535
Number of controls and sections added over the lifetime of a form / report
754
Number of characters in a SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control.
32,750
Macro & VBA Limits
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
Number of modules (includes forms and reports with the HasModule property set to True)
This is a quick post to lay out the limits in Access 2007 and make a little clearer how the application works and how it scales. The first table below shows the limits of the database engine itself.
Access Database Limits
Access database (*.mdb or *.accdb) file size
2 gigabytes, including all objects in the database (data, forms, reports, indices, macros, modules, etc.)
Total number of concurrent users
255. Note that the practical limit will likely be lower than this based on database design.
Table Limits
Number of tables
This is governed by a limit on the number of objects in the database, which includes tables, forms, reports, queries, etc. The limit on DB objects is 32,768.
Table size
2 gigabytes, less the space needed for system objects
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 Note that this includes internal tables opened by Access.
Number of characters in a text field
255
Number of characters in a memo field
65,535 when text is entered through the UI
1 gigabyte if text is entered programmatically
Size of an OLE Object field
1 gigabyte
Number of indexes on a table
32
Number of fields in an index or primary key
10
Number of characters in a validation rule
2048
Number of characters in a validation message
255
Number of characters in a record (excluding Memo and OLE Object fields) when the UnicodeCompression property is set to Yes.
4,000
Number of characters in a field property setting
255
In addition, Access applications themselves have a number of limits, including:
Access Database Limits
Number of objects in a database
32,768 Note that this includes tables, forms, reports, queries, macros, modules, indices, and internal objects used by Access.
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
Table Limits
Number of open tables
2048 Note that this includes linked tables as well as local ones, and that the number may be somewhat lower due to internal tables opened by Access.
Query Limits
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 returned by a query
255
Maximum 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 in a parameter in a parameterized query
255
Number of ANDs in a WHERE or HAVING clause
99
Number of characters in a SQL statement
Approx 64,000
Form & Report Limits
Number of characters in a label
2,048
Number of characters in a text box
65,535
Form or report width
22 inches (55.87cm)
Section height
22 inches (55.87cm)
Height of all sections, plus section headers in design view.
200 inches (508 cm) Note an actual report can be arbitrarily long once the data has expanded.
Number of levels of nested forms or reports
7
Number of fields or expressions that can be sorted or grouped in a report
10
Number of headers or footers in a report
1 report header / footer
1 page header / footer
10 section headers / footers
Number of printed pages in a report
65.535
Number of controls and sections added over the lifetime of a form / report
754
Number of characters in a SQL statement that serves as the Recordsource or Rowsource property of a form, report, or control.
32,750
Macro & VBA Limits
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
Number of modules (includes forms and reports with the HasModule property set to True)
Lembrando que os dados informados pelos colegas, são aplicados [Ô]somente[Ô] em TEORIA.
Na prática, a [Ô]coisa[Ô] é mui diferente.
Na prática, a [Ô]coisa[Ô] é mui diferente.
Um mdb de 50 MB já acho grande, imagina um de 2GB?!?!
Acho que acima de 50 MB ou um pouco mais é recomendável migrar pra um SGBD, tipo Postgre, Sql Server, Firebird, etc...
ACCESS = Medo, Desconfiança, Bugs
Acho que acima de 50 MB ou um pouco mais é recomendável migrar pra um SGBD, tipo Postgre, Sql Server, Firebird, etc...
ACCESS = Medo, Desconfiança, Bugs
Tópico encerrado , respostas não são mais permitidas