Performance Network

Running a database over a network brings up the question of speed and implementation.  Previous versions of Microsoft Access (97-2003) were very slow on a LAN. How slow? In some offices, it would take up to 45 seconds for a report to come up in print preview.

 

What is the slowest part of the database? Forms and reports. The forms are slow because they are big fat elephants stomping on the network. The forms and reports make up 90% of the size of a database. In a 20 MB database, the tables only use 1 or 2 Megabytes.

 

A new database structure

Microsoft Access is built on the XML source code. XML means Extended Markup Language. It is an Internet programming language. As a result of the new file structure, Microsoft Access 2007 databases are much, much smaller and more responsive than older databases.