https://www.webmaster-forums.net/crss/node/1018200 en https://www.webmaster-forums.net/web-database-development/how-many-too-many#comment-1106621 <p>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...</p> <p>Thnx for the reply...<img src="https://www.webmaster-forums.net/misc/smileys/smile.png" title="Smiling" alt="Smiling" class="smiley-content" /></p> Wed, 10 Apr 2002 19:22:28 +0000 openmind comment 1106621 at https://www.webmaster-forums.net https://www.webmaster-forums.net/web-database-development/how-many-too-many#comment-1106594 <p>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.</p> <p>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.</p> Wed, 10 Apr 2002 12:40:03 +0000 Peter J. Boettcher comment 1106594 at https://www.webmaster-forums.net