Question Run-time error '2501': The OpenForm action was cancelled

[Alhousani]

I have a database created by access 2003, this database is in share folder but now for some user a popup message is appearing (Run-time error '2501': The OpenForm action was cancelled).

This error is only appear for some user which they could not open some forms in the database.

In the same PC when other staff try to login to PC then access the database with same username it work fine for them.

Can somebody help me resolving this matter.

 

[CameronM]

First thing I'd do is check the permissions on the folder where the database is located for the users that are having the issue and make sure they have read write permissions.

 

[gemma-the-husky]

this error indicates the form could not open, but is trappable

it may be that the options they are using produce an error (eg no items), or it may be an access security issue - i would be inclined to check the underlying query for the form, to make sure that opens properly

 

[Alhousani]

User is having read and write permission on that folder in addition if user login to another PC in the network he will be able to work in the database. Along with that in the same PC which has problem if another user login he will be able also to use and open the database, only for some particular user.

I don't know may be it related to security issue or any option in the access.

Note: user can open some form and other error message will appear and user also can open the table or query without any problem, only some form or report error 2501 will appear.

 

[CameronM]

It may also be some kind of issue with references. Missing references tend to throw up strange errors. The reference issue could arise if that user had installed some software on the problem PC, which over-writes some of the required DLL's.

References do not usually stop you opening the tables, which could explain why the user can do that, but not open forms/reports.

To check the references, have the user log into the PC and in Access go to the VBA editor window, look under Tools\References to see if there are any marked "missing".