ms access training courses in london - Rows

The UK's most regular instructor-led training courses.
Training information: ms access training courses in london · Microsoft access courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Rows

Lisa has attended:
Excel Advanced course
Access Introduction course

by - delegate Lisa [2 posts] (2007 Feb 1 Thu, 09:34) Reply

What is the maximum number of rows & columns access can hold?

Version	Date	Location	Places available	Book	Next place rate:
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Oct 24 Fri	Bloomsbury	7	book now	£203	£230
2003	2008 Oct 29 Wed	Bayswater	6	book now	£214	£230
2003	2008 Nov 5 Wed	Southwark	6	book now	£214	£230
2003	2008 Nov 21 Fri	Bloomsbury	6	book now	£214	£230
2003	2008 Nov 26 Wed	Bloomsbury	5	book now	£219	£235
2007	2008 Nov 28 Fri	Bloomsbury	5	book now	£235	£240
Full Schedule: See all 51 Access Advanced course dates. Bookings currently available until 25th November 2009.

RE: Rows

by - trainer Richard platinum contributer [812 posts] (2007 Feb 1 Thu, 13:10) Edited on 2007 Feb 1 Thu, 14:16 Reply

Max Fields (Columns) = 255
Max Records = none specified. This is limited by the size of the whole database and the storage capacity available.

RE: Rows

by - trainer Andrew gold contributer [441 posts] (2007 Feb 1 Thu, 13:16) Reply

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

· Microsoft Access Training Opens Doors
· Do You Have Trouble Understanding Databases? Consider a One-on-One Access Course
· Microsoft Access: Unleash the True Potential Today
· 3 Useful Things You'll Learn in Microsoft Access Training Courses
· Microsoft Access Courses