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

ResolvedVersion 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:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips

ms access training courses in london - Rows

Rows

RE: Rows

RE: Rows

Access articles

Access tip:

Random sampling