By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,824 Members | 2,359 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,824 IT Pros & Developers. It's quick & easy.

Maximum records that Access can accommodate

P: 1
Hi,

I encountered a problem while using MS Access as my backend. It just accepts 32,767 records. Is this a limitation of MS Access?
Jun 9 '07 #1
Share this Question
Share on Google+
2 Replies


ADezii
Expert 5K+
P: 8,636
Hi,

I encountered a problem while using MS Access as my backend. It just accepts 32,767 records. Is this a limitation of MS Access?
Microsoft Access Specifications
Jun 9 '07 #2

missinglinq
Expert 2.5K+
P: 3,532
What are you using as your frontend? Are all these records residing in a single table or multiple tables? A couple of thing strike me off hand. First that your number 32768 is the limit of an Integer in Access, and secondly that 32768 is the number of Objects allowed in Access. It's almost as if each record were being sent to Access as an object. In response to your question viv a vis a record limit, the answer is no, there is no record limitation as such. You're only limited by the 2 GB size of the file.

Let us know more about your entire setup.
Jun 9 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.