rockydee
asked on
code builder will not work in forms on Access 2003
I have one Access 2003 program that works perfectly fine on Terminal Server 2008 but another one that does not. Everything works fine except the forms. I get the "object or class does not support the set of events" error. I am unable to get the code builder on the form to work. I have tried the following:
1. Created a new database and pulled all of the objects from the old one.
2. Taken the one that does work, deleted all objects, imported from the one that does not.
3. Made sure that all macros are enabled.
4. Set the directory as a trusted center.
5. Verified that the references in both databases are exactly the same.
6. Verified that Track Name AutoCorrect is off
7. Compiled the database - no errors
8. Compact and repair
9. Decompiled and recompiled
Where do I go from here?
1. Created a new database and pulled all of the objects from the old one.
2. Taken the one that does work, deleted all objects, imported from the one that does not.
3. Made sure that all macros are enabled.
4. Set the directory as a trusted center.
5. Verified that the references in both databases are exactly the same.
6. Verified that Track Name AutoCorrect is off
7. Compiled the database - no errors
8. Compact and repair
9. Decompiled and recompiled
Where do I go from here?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
to puppydogbuddy:
1. I am running Access 2003 only on the terminal server - I assume that is what you mean by multiple versions.
2. mscomct2.ocx is the file on the system
to lsmconsulting:
1. The app runs fine outside the TS environment
2. The references work fine in 2 other apps I have out there which says to me they are working fine and they are
a. Visual Basic For Applications
b. Microsoft Access 12.0 Object Library
c. OLE Automation
d. Microsoft DAO 3.6 Object Library
e. Microsoft ActiveX Data Objects 2.1 Library (have tried higher versions as well with no difference)
3. It is not a new app just placed recently on the TS and it works fine elsewhere
4. Office/Windows is fully updated on the TS
5. The user launches a bat file that checks for a newer version which it copies down if there is. The same type of bat file that is used for the other two apps that have no problems
Hope that answers your questions and many thanks for working with me on this.
1. I am running Access 2003 only on the terminal server - I assume that is what you mean by multiple versions.
2. mscomct2.ocx is the file on the system
to lsmconsulting:
1. The app runs fine outside the TS environment
2. The references work fine in 2 other apps I have out there which says to me they are working fine and they are
a. Visual Basic For Applications
b. Microsoft Access 12.0 Object Library
c. OLE Automation
d. Microsoft DAO 3.6 Object Library
e. Microsoft ActiveX Data Objects 2.1 Library (have tried higher versions as well with no difference)
3. It is not a new app just placed recently on the TS and it works fine elsewhere
4. Office/Windows is fully updated on the TS
5. The user launches a bat file that checks for a newer version which it copies down if there is. The same type of bat file that is used for the other two apps that have no problems
Hope that answers your questions and many thanks for working with me on this.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Found the problem. I was unaware that my IT person had loaded both Access 2003 and 2007. The programs were trying to load under 2003. When I had them load under 2007, everything worked fine. Thank you, puppydogbuddy, for suggesting multiple versions could be the problem. I am awarding the points to puppydogbuddy. Thank you, lsmconsulting, for taking the time to respond to this question.
What references do you have in the the trouble app? Are you 100% certain that they are installed correctly?
Did this just occur, or is this a new app just installed?
Have you fully updated the Office/Windows installs on the TS box?
How does the user launch the application? Is there a shortcut?