library

Instructions for installation of the CS2 MS Access Database Application:

PLEASE read and complete the following installation instructions. It may help to print these instructions so you may refer to them during installation.

1. System/Software Requirements:

Operating system - Windows 98, Windows 2000, or Windows XP
Either Access 2000 or Access 2002 loaded on your individual PC
Either Word 2000 or Word 2002 loaded on your individual PC

2. Highlight the MS Access database file entitled “CS2.mdb” that you downloaded from the NAVREF email. Use the “Extract” feature in WinZip to save the file either to your network drive (so that others can share it) or to your PC’s hard drive. You can place it in any directory on the network or on your local drive. Note: It will “work” faster off your local hard drive, but you’ll lose the ability to share it with others.

If you have copied the CS2 database to your network and would like to set its options for multiple users, please read and follow the directions under Section 6 below entitled: “Set options for a shared Access database”. (You may need technical assistance of someone knowledgeable about MS Access and your network.)

3. You may want to add an icon on your desktop to make it easier and quicker to open the database application.

4. To start CS2, click on the program icon you’ve created on your desktop or use Windows Explorer to find the file and then double-click on it. When you open the program, it will automatically open to CS2’s Main Menu. Be sure that the first time you open the CS2 database and before you click on the button entitled “GETTING STARTED”, you’ll need to turn off one feature of MS Access. This step needs to be done on every PC that will utilize the CS2 database. From the MS Access Menu at the top of your screen,

Click on “Tools”
Click on “Options”
Select the Tab labeled “EDIT, FIND”
Under the CONFIRM section of that tab, uncheck the boxes labeled, “Record Changes”, “Document Deletions” and “Action Queries” (see picture below).
After unchecking those boxes, click the button “APPLY, then click button “OK”

Note: Turning this feature off makes the program run faster and eliminates all of the unnecessary and tedious “Yes-No” confirmations you’d otherwise have to answer each time a change is made to the database.

5. Your program is now ready for customization. From the CS2 database menu - click on the button labeled “Getting Started” and follow the instructions provided in the help screens.

6. Setting CS2 Options for a shared Access database.

On the Tools menu, click Options.

Click the Advanced tab.

Do one or more of the following:

Under Default open mode, do one of the following:

If you want others to be able to open the database at the same time you have it open, click Shared.

If you want sole access to the Access database when you have it open, click Exclusive.

Note: Even if you have set the default open mode to “Shared”, you can temporarily override this setting at the time you open an Access database.

If you (or your technical expert) have set up security in your multi-user network environment, you can ensure that users don't open an Access database exclusively by denying them Open Exclusive permission for the database.

You’ll also need to specify the update retry and refresh interval settings. To do so do one or more of the following:

a) To set the interval after which Microsoft Access automatically tries to save a changed record that is locked by another user, type the number of milliseconds in the Update retry interval box. Valid values are 0 through 1,000.

b) To set the number of times Microsoft Access tries to save a changed record that is locked by another user, type a number in the Number of update retries box. Valid values are 0 through 10.

c) To set the interval after which Microsoft Access automatically refreshes records that you're accessing, type the number of seconds in the ODBC refresh interval box. Valid values are 1 through 32,766.

d) To specify how often data is automatically updated, type the number of seconds in the Refresh interval box. Valid values are 1 through 32,766 seconds. For example, if you type 120, the data is updated every 2 minutes. This setting takes effect only if the database is shared on a network.

e) You’ll also need to “Specify the record locking strategy.” When a user edits a record, Microsoft Access can automatically prevent others from changing that record until the user has finished editing it. Giving one user exclusive access to a record is called locking. Under Default record locking, do one of the following:

f) To prevent locking of records while you edit them, click No locks.

g) To lock all records in the form or datasheet (and the underlying tables) while you edit them, click All records.

h) To lock only the record you're editing, click Edited record.

i) You’ll also need to “Specify record-level or page-level locking,” Do one of the following:

· To make record-level locking the new default setting for CS2 database, select the Open databases using record-level locking check box.

· To make page-level locking the new default setting for the current Access database, clear the Open databases using record-level locking check box. This setting takes effect the next time you open the Access database, but you must use the Open command on the File menu rather than the list of most recently used files at the end of the File menu.

last updated: 01/31/08