Preparing and Attaching an Elderberry Database System


The Elderry Database System requires Microsoft Access 2000 or Microsoft Access 2003 be installed on the workstation.

——————————————————————————
Initial File Preparation on a Host Server or Workstation
On the computer that will serve as the data host:

The database system is comprised of three files:
ElderberryVersionX.mdb – X represents the current version number
ElderberryData.mdb – Elderberry data file
MouseHook.dll

Only one computer will contain the Elderberry data file, while more than one computer can be used to view or enter and edit data.

Create a folder called Elderberry Database on the host workstation or server.
If other workstations are going to require access to  the database, make sure the folder is shared or included in a network share path.

Copy the three files from the installation CD to the Elderberry Database folder.

Check the two .mdb files, make sure they are not marked as Read Only.

——————————————————————————
Installation on a Workstation
On the workstations that will access the database:

Create a folder called Elderberry Program in the root of Drive C.

Copy the files named ElderberryVersionX.mdb and MouseHook.dll from the installation CD or from the host server location to the Elderberry Program folder.

If necessary, change properties of the ElderberryVersionX.mdb file so that it is not Read Only.

Create a Desktop shortcut for the ElderberryVersionX.mdb. This shortcut will serve to open the database system.
Windows 7 – Put shortcut in the Users\Public\Desktop folder (requires elevation) for all users to see it.

Attach the database as shown below to attach the front and back ends of the database system.

——————————————————————————
Attach Database
On the workstations that will access the database:

The database system is comprised of two Microsoft Access files.

The ElderberryVersionX.mdb is the front end of the database system. It provides the user interface, such as the forms and buttons.
The ElderberryData.mdb is the back end of the database system. It contains all of the data entered by users of the program.

In order for the database system to function properly, the front end and back end must be attached.

Double-click on the ElderberryVersionX.mdb desktop shortcut

If prompted to block unsafe expressions, select No.

If you see a Security Warning asking Do you want to open this file, select Open

From the top-line menu within Access 2003, select Tools \ Macros \ Security

Select Low Security

Close Microsoft Access

Double-click on the ElderberryVersionX.mdb desktop shortcut

click Attach Database

From the Attach Database window, click BROWSE

Browse to the ElderberryData.mdb file on the host server or workstation.

Select the file and click Open

From the Attach Database window, click on ATTACH DATABASE.
It may not appear as though anything is happening, wait 10 to 20 seconds.

When you see the Attach Completed pop-up, select OK.

Close and reopen Elderberry.

You can now login to Elderberry

Advertisements