KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
We know the MS Access database engine is 'throttled' to allow a maximum file size of 2GB (or perhaps internally wired to be limited to fewer than some power of 2 of 4KB data pages). But what does this mean in practical terms? To help me measure this, can you tell me the maximum number of rows that can be inserted into a MS Access database engine table? To satisfy the definition of a table, all rows must be unique, therefore a unique constraint (e.g. PRIMARY KEY , UNIQUE , CHECK , Data Macro, etc) is a requirement. EDIT: I realize there is a theoretical limit but what I am interested in is the practical (and not necessarily practicable ), real life limit.
Tags (comma-separated)
Save Edits
Cancel