98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access training courses in london - Rows
ms access training courses in london - Rows
Resolved · Low Priority · Version Standard
Thu 1 Feb 2007, 09:34Delegate Lisa said...
Lisa has attended:
Excel Advanced course
Access Introduction course
Rows
What is the maximum number of rows & columns access can hold?
Thu 1 Feb 2007, 13:10
Edited on Thu 1 Feb 2007, 14:16Trainer Richard said...
RE: Rows
Max Fields (Columns) = 255
Max Records = none specified. This is limited by the size of the whole database and the storage capacity available.
Thu 1 Feb 2007, 13:16Trainer Andrew said...
RE: Rows
Hi Lisa
Thanks for your question. An Access 2003 table can hold up to 255 fields (or columns) and Access can handle up to 2048 open tables. If your database is on this scale however you would probably be better looking at moving up to a more powerful database solution like Microsoft SQL.
Hope this helps.
Kind regards,
Andrew
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Splittng a databaseSplit your database into two (at least). |
