ms access training courses in london - Rows

Resolved · Low Priority · Version Standard

Thu 1 Feb 2007, 09:34 Delegate 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:16 Trainer 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:16 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips