Access stability for large DBs

Resolved · Low Priority · Version 2007

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

Nick has attended:
Access Intermediate course

Access stability for large DBs

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

Fri 17 Jul 2009, 09:11 Trainer 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 tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips

Access stability for large DBs

Access stability for large DBs

RE: Access stability for large DBs

Access articles

Access tip:

Compact database automoatically