I have been developing databases for my company for some time now. All have a default "splashscreen" form that opens up when the database is opened by a user. In the background VBA runs on the "on open" event of the form to validate who the user is via their windows username. All my databases are distributed as compiled accde files and users open them with Ms Access Runtime. They have been running fine over the years with anything from 20 to 50 users opening them each week.
In recent weeks a number of users have been receiving the following error message as soon as the database opens "The expression On Open you entered as the event property setting produced the following error: Requested type library or wizard is not a VBA project". All users experiencing this error have been opening and using the database fine prior to it occurring. Once it occurs they are unable to open the database again, even if I send them a fresh accde file.
I am at a loss to understand what is happening, the database has not changed.
Any help appreciated.
In recent weeks a number of users have been receiving the following error message as soon as the database opens "The expression On Open you entered as the event property setting produced the following error: Requested type library or wizard is not a VBA project". All users experiencing this error have been opening and using the database fine prior to it occurring. Once it occurs they are unable to open the database again, even if I send them a fresh accde file.
I am at a loss to understand what is happening, the database has not changed.
Any help appreciated.