Verify that the latest operating system service pack is installed
Install the latest operating system service pack.
To verify that you have the latest service pack installed for your
operating system, visit the following Microsoft Web site:
http://windowsupdate.microsoft.com
Verify That the Latest Microsoft Jet
Service Pack Is Installed
Install the latest Microsoft Jet service pack. This makes sure that
you have the latest bug fixes to Microsoft Jet. To download the
latest Jet 4.0 Service Pack, see the following Microsoft Knowledge
Base article:
Obtain
the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
Periodically Compact Your Microsoft Jet Database
Parts of the database may become fragmented. Therefore, it is a good
idea to periodically run the JetComp utility.
For additional information about how to obtain the JetComp Utility
for Microsoft Jet 4.0, click below to view the article in the
Microsoft Knowledge Base:
Jet Compact Utility Available in Download Center
Schedule compacts depending on how much the data changes. If the
data does not change that often, you do not have to compact that
much. If there are many and frequent new users and updates compact
more. Even though there is no formal rule for how often to compact,
we recommends that you compact on a regular basis.
The next few paragraphs explain the compacting process that is used
by Microsoft Jet in more detail. For a more general explanation of
compacting a database, click below to view an article in the
Microsoft Knowledge Base:
Defragment and Compact Database to Improve Performance
The Microsoft Jet engine treats a Microsoft Access database file as
a series of 4096-byte blocks, much in the same way as a typical file
system treats data on your hard disk. The complete set of records in
a Microsoft Jet table is stored by series of these blocks, each
block pointing to the next block. Each block can hold one or more
records, depending on how many fields and how much data is in each
record. Over time, when records are added and deleted from the
table, the table blocks will become fragmented inside the database
file.
Compacting a Microsoft Jet database "defragments" these blocks and
tries to place each table in a contiguous range of blocks. This
improves read and write performance to the table.
Indexes in a Microsoft Access database are also stored in 4096-byte
blocks, and can become fragmented just as the table records can.
Back Up Your Microsoft Jet Database File on a Regular Basis
It is best to choose a backup schedule that corresponds to the
amount of data you can afford to lose. For example, if you cannot
afford to lose more than a day's worth of data, back up on a daily
basis. If you can afford to lose a week's worth of data, back up
weekly, and so on. A full database file backup is the best way to
make sure that you can recover your Microsoft Jet database file if
corruption occurs.
Important, you must shut down the website hosting DDNSServ before
you back up the database file. If you do not, you may create a
backup file with incomplete or inconsistent data. Test your backups
regularly to make sure that your backups are good.
Use a Robust File Server
Make sure that you have a robust file server that can handle the
number of users and the requests that are being made to the
Microsoft Jet database file. Additionally, make sure that the file
server is not overtaxed with handling many other processes, such as
acting as a Windows Domain Controller, Exchange Server, and SQL
Server. The reason for this recommendation is that a network
administrator, or another owner of the server, may reboot the
computer to fix a problem with another important service (such as
the mail server), or may reboot after applying new software, a
service pack, or hotfix, and may forget that the Microsoft Jet
database is currently shared on the server. Rebooting the file
server will cause unexpected interruption of the client connections
to the database and may cause database corruption.
A robust file server must also be placed in a secured location where
it cannot be accidentally switched off. The server must have an
uninterrupted power supply (UPS) to protect it from intermittent
power outages or power fluctuations. The network file server must
also have high performance hard drives, a good network card, and
plenty of RAM to make sure that the server can handle the load that
is placed on it.
Verify Network Connectivity
Make sure that you have a stable and fast internet connection.
|
