Tried hard to write an appropriate title but I dont know what the problem is sorry.
I have a large database:
Tables: 74
Queries: 253
Forms: 114
Reports: 121
Modules: 10
Database is in use with multiple users and I edit it making small tweaks as required. I have been trying to make a small mod for the last 2 weeks without any success. For example if I just change the version number (a public variable in a module) then create an MDE file the MDE will not open instead come up with the error:
"The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events."
Steps taken so far to resolve the issue:
1. Check all references: they seem fine and I can create an MDE if I dont make any changes so their can't be a problem with references. To be sure I removed references, re-registered and added them back in - still no luck
2. Rebuild database in case corrupt: created a new database and linked and imported all objects. Even without any changes this new database could not create an MDE that would run.
3. Try to pin point problem: changed the database to just run (from start-up) a simple form with a single cmd button. Form loaded but clicking on the button produced the same error, even with no code in the OnClick procedure.
Next step: Recreate the database with all the tables and queries and then add one object at a time. That could be a very lengthy process. If anyone has any better ideas I would love to hear from you.
Thanks,
Rob
I have a large database:
Tables: 74
Queries: 253
Forms: 114
Reports: 121
Modules: 10
Database is in use with multiple users and I edit it making small tweaks as required. I have been trying to make a small mod for the last 2 weeks without any success. For example if I just change the version number (a public variable in a module) then create an MDE file the MDE will not open instead come up with the error:
"The expression On Open you entered as the event property setting produced the following error: Object or class does not support the set of events."
Steps taken so far to resolve the issue:
1. Check all references: they seem fine and I can create an MDE if I dont make any changes so their can't be a problem with references. To be sure I removed references, re-registered and added them back in - still no luck
2. Rebuild database in case corrupt: created a new database and linked and imported all objects. Even without any changes this new database could not create an MDE that would run.
3. Try to pin point problem: changed the database to just run (from start-up) a simple form with a single cmd button. Form loaded but clicking on the button produced the same error, even with no code in the OnClick procedure.
Next step: Recreate the database with all the tables and queries and then add one object at a time. That could be a very lengthy process. If anyone has any better ideas I would love to hear from you.
Thanks,
Rob
