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

Max number of fields in MSAccess

P: 1
Sorry but I am a newbie and this question is very basic.

What is the total number of fields I can have in a MS Access database.

Sep 22 '08 #1
Share this Question
Share on Google+
2 Replies

Expert 5K+
P: 8,692
I do believe the Maximum number of Fields you can have in any one Table is 255 and the Maximum number of 'Open' Tables is 2,048 (minus Internal Tables used by Access).

Microsoft Access Specifications
Sep 22 '08 #2

P: 69
You could get round these limitations by designing a split system with multiple back ends, but the reality is that if you are up at those sorts of numbers, you really need to go back and ask yourself what you are really trying to do. Tables with 255 fields or a database with thousands of tables would in all likelihood be a maintenance nightmare!
Sep 23 '08 #3

Post your reply

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