advanced microsoft access training london

advanced microsoft access training london - Tables in MA

Resolved · Low Priority · Version Standard

Tables in MA

Brian has attended:
Access Intermediate course
Access Advanced course

by - delegate Brian [4 posts] (2007 Mar 16 Fri, 16:53) Reply

Is there a maximum limit to the amount of tables Access can hold? Additionally is there a limit to the fields a table can hold?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	6	book now	£450	£485
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
2003	2009 Mar 5 Thu + 6 Fri	Southwark	7	book now	£345	£399
2003	2009 Apr 8 Wed + 9 Thu	Southwark	8	book now	£275	£399
2003	2009 May 7 Thu + 8 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 12 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: Tables in MA

by - trainer Pete platinum contributer [799 posts] (2007 Mar 17 Sat, 09:52) Reply

Hello Brian,

Thanks for the question, Looking through my books I can only find partial answers to your question, What I have found relates to Access 2000, Max database size = 2GB, Max TableSize = 1GB, Max number of objects in a database = 32,768, Max number of modules in a database = 1000, Max number of fields in a table = 255. Hope that helps.

· Why a Microsoft Access Course Could Change the Way You Do Business
· Access VBA Handling Errors and Debugging Code
· Microsoft Access Tighten your Security Controls
· Microsoft Access, an Efficient Database Tool
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.