حداکثر تعداد رکورد در اکسس

[ebadian]

سلام
لطفا من را راهنمائی بفرمائید
در اکسس حداکثر چند تا رکورد در یک جدول می توان داشت .
در ضمن جهت گنجایش بالاتر از 100مگابایت این بانک مورد اطمینان است

[Milad Mohseny]

سلام دوست عزیز
در این سایت یه امکانی به نام جستجو وجود دارد .

[programerinfonet]

سلام دوست عزیز :
دقیقأ نمی دونم ولی بعید می دونم بیشتر از 10000 رکورد بتونه نگهداره با حداقل با اشکال مواجه می شه

[fazl11]

دوست عزیز من تا 4 میلیون هم کار کردم ولی کند میشه البته ناگفته نماند مونده به اینکه بانکتو چی جوری طراحی کرده باشی یعنی سعی کنی کمتر توی بانکت تکست ذخیره کنی و تبدیل به عدد کنی بهتره و بانکت کم حجم و سریعتر میشه
در ضمن منم دقیقا نمیدونم تا چه حدی میتونه جواب بده

[mobtakercode]

نمی دانم چرا بعضی با این سوال مواجه می شوند که حداکثر تعداد رکورد در یک جدول در اکسس چقدر است؟

اگر فرض کنیم هر دقیقه یک رکورد به جدول شما اضافه شود روزانه می شود 1440 رکورد و سالانه می شود 525600 رکورد.

که ظرف 10 سال می شود 5256000.

که طبق شواهد و ازمایشات دوستان جداول اکسس با چندین میلیون رکورد مشکل پیدا نمی کنند

[bita_ziba77]

با سلام
بارها در اين رابطه بحث شده است علي ايحال محدوديت حداكثر حجم بانك اطلاعات 2 گيگابايت مي باشد. شامل جداول - فرم ها و ...
و ساير محدوديت ها:

Access 2007 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) 1,000