Installing FRED

1) Install MySQL ODBC driver (version 3.51 or later)

http://www.mysql.com/products/connector/odbc/

2) Update MS Access Jet engine to Jet 4.0 SP8. Choose the download for your version of Windows.

http://support.microsoft.com/default.aspx?scid=kb;en-us;829558#EVACAAA

3) Create ODBC DSN entry for MySQL database installed earlier
	a) (Windows 2000) Start>Settings>Control Panels>Administrative Tools>Data Sources
	   (Windows XP) Start>Control Panels>Administrative Tools>Data Sources
	b) Click System DSN tab
	c) Click Add button
	d) Choose MySQL ODBC driver and click Finish
	e) In the Add Data Source Name window enter the following:
		Data Source Name: biolad
		Server: 127.0.0.1 (or hostname/IP where you installed MySQL)
		User: debuser
		Password: <password entered earlier for debuser>
		Database: Choose the database you created earlier
	f) Click the Test button to verify the data. 
	   You will see "Success; connection was made!" if the information is correct
	g) Click OK twice to save the DSN and exit


4) Copy FRED.mdb to your DEB installation directory.

5) You will need to update the deb.ini file to point to the location of FRED.
	a) Open the deb.ini file located in the deb installation directory.
	b) Locate the line that reads fred=FRED.mdb
	c) Update the value to the full path of the FRED.mdb file.
		ex: fred=C:\deb\FRED.mdb


6) You will need to re-link the tables in Access before you can use FRED.
	a) Open FRED.mdb
	b) Choose Linked Table Manager on the menubar
	c) Click Select All
	d) Check Always prompt for new location
	e) Click OK
	f) Click the Machine Data Source tab
	g) Choose the biolad DSN in the list
	h) Click OK - you will see a confirmation message.
	i) Click OK and Close.