This can occur with Total Access Memo for a few reasons:
1. If you have the Name AutoCorrect Option for the database enabled at runtime and relink tables, you cause the form containing the ActiveX control to be opened by MS Access in design view and saved. This causes the ActiveX control to lose it's license because the license is not available in runtime.
To workaround this issue, please ensure that the "Name AutoCorrect" options are turned off prior to relinking your tables (manually or programmatically).
Manually disable the Name AutoCorrect Option:
The Name AutoCorrect options are found under: Tools, Options, General Tab. Uncheck "Track name AutoCorrect info". Now you can use the Link Table Wizard to relink tables or relink them programmatically.
Programmatically disable the Name AutoCorrect Option:
STEP 1: Create variables to hold the values. Do this in the Declarations section of the form:
Private fTrackNameAutoCorrectInfo As Boolean Private fPerformNameAutoCorrect As Boolean Private fLogNameAutoCorrectChanges As Boolean
STEP 2: Set variables equal to existing database settings
' Record the value of the Track Name Autocorrect and other options into the module level variables (above) fTrackNameAutoCorrectInfo = GetOption("Track Name AutoCorrect Info") fPerformNameAutoCorrect = GetOption("Perform Name AutoCorrect") fLogNameAutoCorrectChanges = GetOption("Log Name AutoCorrect Changes")
STEP 3: Turn Name AutoCorrect options OFF *before* you relink the tables
' Once Tracking is turned off, the rest are automatically disabled Application.SetOption "Track Name AutoCorrect Info", False ' 'RELINK YOUR TABLES AFTER THE OPTION IS TURNED OFF! '----- Perform your programmatic relink here -----
STEP 4: Set Name AutoCorrect options to their original settings again
SetOption "Log Name AutoCorrect Changes", fLogNameAutoCorrectChanges SetOption "Perform Name AutoCorrect", fPerformNameAutoCorrect SetOption "Track Name AutoCorrect Info", fTrackNameAutoCorrectInfo
2. If you are trying to use this control in an environment outside of Microsoft Access. This control is only supported in the MS Access environment, and should not be used in any other application.
3. This issue can occur when distributing an application and the runtime executable was not run on the user's machine. This is an important part of the redistribution/runtime process. Please ensure that you have run this executable once on every machine which this run-time application is distributed. For more information regarding the Runtime distribution, please review the manual or help file.
4. One of the shared files which our program uses was changed by another program that installs an older version. To resolve this, you should be able to simply run the runtime executable again to overwrite these files. If this does not work, you need to find out what new software was installed by your users and see which files might were affected.
5. A reference to the control was lost. To resolve this, open any module. Then go to Tools | References menu and look for references listed as "MISSING". Also, ensure that the reference to our control is listed. If it is not or it is with "MISSING" next to it, you need to reset this reference. You can do so by removing the missing reference and using the browse button to locate the fmsmemo9.ocx control. This file is usually located in the C:\Windows\System folder.
6. Please ensure that you did not copy and paste the control from one form to another, or on the same form. Although this method of inserting an ActiveX control usually works on a development machine, it causes issues on the user's machine. The proper way to place the control is through the Insert | ActiveX Control method each time.
Unfortunately, this also applies to copying an entire form or report with an ActiveX control in it. When you copy a form or report, Microsoft Access Actually copies each control individually then pastes them again in the appropriate places wherever you paste the new form. Using this method is essentially the same as copying the control itself and it will not work.
7. This can happen if you have had the demo version installed previously, and still have your references set to the Trial version of the control, or inserted the trial version of the control. To resolve this, you can do this two different ways:
A. When going to Insert | ActiveX Control, and scroll down this list. The area which you want to look at is FMS Total Access Memo. If you have the trial version still installed, or did an automatic uninstall, there should be another saying FMS Total Access Memo Trial. If this is the case, please ensure that you are selecting the full version of the control and not the Trial version.
B. Un-Install and Re-install
- Do an uninstall of the Full version and Trial version of the product. You can do this by going to the control panel and using Add/Remove programs.
- After the uninstall is complete, go to the location where the products were installed. If there is a folder left for either one, please delete them.
C. Please reinstall the full version of the product only.