Converting MedRefs to Run In Microsoft Access 2000
& Later Versions of Access

Note: This technique has not been extensively tested, and is described here solely for the convenience of experienced users of Access 2000 and more recent versions.  For users of Access 97, please click here.  Medrefs has not been tested in versions of  Access beyond Access 2000.

(1) First download and install the MedRefs program (Access 97 version).  This installation will include the Access 97 version of the file Medrefs.mdb, which will not run correctly in Access 2000 without conversion.

(2) If you have a standard unmodified installation of Access, you will be the user "Admin" when you logon by default and can ignore this paragraph.  However, if  you do not or cannot logon as "Admin", join an Access workgroup file ( such as system.mdw provided with Access 2000) which gives you permission to logon as user "Admin".  You may need to create a special workgroup file to allow you to do this.  Use the Workgroup Administrator program (wrkgadm.exe) provided with Access 2000 for these tasks.

(3) Start Access 2000 (i.e., msaccess.exe).  Confirm that you have logged on as Admin by selecting Tools | Security | User and Group Accounts.  Confirm that the dialog box that comes up when switching to tab "Change Logon Password" shows that you are user "Admin". 

(4) Create a new empty database named Medrefs2K.mdb using File | New | Database in Access 2000.  Run File | Get External Data | Import and specify the Access 97 Medrefs file Medrefs.mdb to import from.  In the tabbed dialog box that comes up, do Select All for all tables, queries, forms, reports, macros, and modules.  For Options, be sure Import | Relationships is checked along with Import Tables | Definitions and Data and Import Queries | As Queries.  Press Ok.  This will import the entire Access 97 version of medrefs.mdb into a new Access 2000 database owned by user "Admin". 

(5) Open the module GlobalRoutines in the new file.  Select Tools | References and look for any items on the list which say "missing" (often this is "Utility.mda" or "Utility").  Browse in your installation of Access 2000 (the same directory in which msaccess.exe is located) to find the file called Utility.mda and add it to the list of references.  Add or correct any other reference that needs to be corrected.    Be sure that either "Microsoft DAO 3.6 Object Library" or "Microsoft DAO 3.51 Object Library"  is checked (or a higher version if appropriate).  Select Debug | Compile and make additional References adjustments as described until the modules all compile without any error message.

(6) Close the new database, and rename it medrefs.mdb.  Copy this file to the directory where you have installed Medrefs, overwriting the original Access 97 version of medref.mdb.

(7) Open the new file medrefs.mdb in Access 2000.

(8) Caution: Do not open directly and convert the file Medrefsd.mdb to Access 2000 format.