I think the maximum number of columns (fields) Access can handle is 255. There is no maximum number of rows, this is limited by database file size, which for Access 2000 is 2GB.
Be warned though if you have a table approaching these limits performance is going to degrade, you should be using SQL Server or MySQL for tables of this size.
I thought it might be 255 but wasn't sure so thanks Peter! As for the degredation, that shouldn't present an issue as I have around 60 fields but only one row at the moment. The table is used to store forum variable such as colors, fonts, etc...
Thnx for the reply...
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.
Peter J. Boettcher posted this at 12:40 — 10th April 2002.
They have: 812 posts
Joined: Feb 2000
I think the maximum number of columns (fields) Access can handle is 255. There is no maximum number of rows, this is limited by database file size, which for Access 2000 is 2GB.
Be warned though if you have a table approaching these limits performance is going to degrade, you should be using SQL Server or MySQL for tables of this size.
PJ | Are we there yet?
pjboettcher.com
openmind posted this at 19:22 — 10th April 2002.
He has: 945 posts
Joined: Aug 2001
I thought it might be 255 but wasn't sure so thanks Peter! As for the degredation, that shouldn't present an issue as I have around 60 fields but only one row at the moment. The table is used to store forum variable such as colors, fonts, etc...
Thnx for the reply...
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.