CharlieT302
Instructor
Hi All,
A company I work for has a database (Access 2003) that they have been working with for several years. This past week, a couple of users were unable to open a form.
When attempting to open the form thru the supplied controls, they receive the message: The OpenForm Action Was Cancelled.
Upon further examination, the form (along with others) would not open in form view or design view even when accessing thru the Main window.
Here is the key point to all of this:
This happens for "some" user accounts on some machines. Those same Access user accounts will work on other machines. The account permissions have all been checked. They are fine and have not changed in the last few years. It appears to be related to the Windows Profile.
Supposedly, nothing has changed with the profiles. I have been told that they have tried deleting an account to restore the default, but this has not restored functionality. As I said, this happened "all of a sudden" after a few years.
Any ideas why this is happening and what can be done to correct it?
A company I work for has a database (Access 2003) that they have been working with for several years. This past week, a couple of users were unable to open a form.
When attempting to open the form thru the supplied controls, they receive the message: The OpenForm Action Was Cancelled.
Upon further examination, the form (along with others) would not open in form view or design view even when accessing thru the Main window.
Here is the key point to all of this:
This happens for "some" user accounts on some machines. Those same Access user accounts will work on other machines. The account permissions have all been checked. They are fine and have not changed in the last few years. It appears to be related to the Windows Profile.
Supposedly, nothing has changed with the profiles. I have been told that they have tried deleting an account to restore the default, but this has not restored functionality. As I said, this happened "all of a sudden" after a few years.
Any ideas why this is happening and what can be done to correct it?