|
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. Forms and Reports make up 90% of
the size of a database. In a 20 MB database, the Tables use only use
1 or 2 MB.
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 and 2010 databases
are much, much smaller and more responsive than older databases.
|
|
| |
