The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access stability for large DBs

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Access stability for large DBs

Resolved · Low Priority · Version 2007

ReplyWed 15 Jul 2009, 16:46Delegate Nick said...

Access stability for large DBs

Is Access 2007 any more Stable when conatining a large amount of data than Access 2003?

For upcoming training course dates see: Pricing & availability

ReplyFri 17 Jul 2009, 09:11Trainer Stephen said...

RE: Access stability for large DBs

Hi Nick

Thank you for your question

After some research there is little evidence that access 2007 is any different from Access 2003 in terms of data storage and stability.

The stability of an access database when storing large amounts of data is actually most determined by the number of simultaneous users. Assuming that you have split the database into a back and multiple front ends then typically 50 or less users can work with a database of around 1GB in size. It should be noted that the maximum size supported by Access is 2GB.

Regards

Stephen

Thu 23 Jul 2009: Automatically marked as resolved.

Access articles

· What's In A Name? Creating A Company Personnel List Using Microsoft Access
· How To Use The Analyze Table Tool In Access
· Want To Find Out About Access Queries?
· Find Microsoft Access Templates For Any Task
· Guide To Adding A Text Box Form Control In Access 2010

Please browse our web site to find out more about
access courses in london and other Microsoft training courses.

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips

Remind me how you create duplicate master

» Forum post: Masters

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions