Banyak yang menanyakan kemampuan database access dalam versi AKUA single client, secara ringkas ms access bisa digunakan hingga 1 GB, tapi sebagai ilustrasi, ada sebuah apotek dibandung yang menggunakan aplikasi akua dari tahun 2003, apotek ini cukup ramai, saat saya lihat datanya di tahun 2005, ternyata belum mencapai 100 MB, bisa dimaklumi karena data data transaksi kebanyakan dalam bentuk text sehingga tidak perlu khawatir kalau database tidak mencukupi.

Berikut adalah informasi mengenai kemampuan database MS Access yang didapat dari help aplikasi tersebut, database ini digunakan untuk AKUA Single Client.

Database Specifications

The following info gives the maximum size for various attributes of a database.

• Database (.mdb) file size 1 gigabyte. Because your database can include linked tables in other files, its total size is limited only by available storage capacity.
• Number of characters in an object name 64
• Number of characters in a user password 14
• Number of characters in a database password 20
• Number of characters in a user name or group name 20
• Number of concurrent users 255

Table Specifications

• The following info gives the maximum size for various attributes of a table.
• Number of characters in a table name 64
• Number of characters in a field name 64
• Number of fields in a table 255
• Table size 1 gigabyte
• Number of characters in a Text field 255
• Number of characters in a Text field for double-byte character sets (DBCS), which require 2 bytes to store a single character 127
• Number of characters in a Memo field 1 gigabyte
• Size of a Long Binary (OLE Object) field 1 gigabyte
• Number of indexes in a table 32
• Number of fields in an index 10
• Number of characters in an index 255
• Number of characters in a validation message 255
• Number of characters in a validation rule 2048
• Number of characters in a table or field description 255
• Number of characters in a record (excluding Memo and OLE Object fields) 2000
• Number of characters in a field property setting 255

Query Specifications

• The following info gives the maximum size for various attributes of a query.
• Number of tables in a query 32
• Number of fields in a recordset 255
• Number of fields in an ORDER BY clause 10
• Number of levels of nested queries 50
• Number of characters in a parameter name 255
• Number of ANDs in an expression 40
• Number of characters in an SQL statement Approximately 64,000