I don't think it's correct to say Jet/ACE is 'throttled' insomuch as it's probably internally wired to be limited to fewer than some power of 2 of 4KB data pages (I'm not getting any nice round numbers trying this out, so there must be some overhead in there somewhere). EDIT: I realize there is a theoretical limit but what I am interested in is the practical (and not necessarily practicable), real life limit. PRIMARY KEY, UNIQUE, CHECK, Data Macro, etc) is a requirement. Create a new desktop database in Access 2013. Click the View Read-Write Connection Information option. Click Manage in the Connections section, and then select From Any Location. In the Access 2013 web client, click Info. It depends on your record size and how efficiently the data is designed. 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. 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).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |