hi there,
i have developed an access database and i have multiple users accessing the database at the same time. For this i have splitted the database in front end and back end. Because i am not in IT department therefore i can't put back end on to the server and install front end on individual's PC. what am i doing is that i have put both the back end and the front end in a shared drive, so the users can access it from there.
my login form does the following tasks on load
1. captures the network user name of the user and compares it with the database if the user exists it allows the user to open their relevant tasks.
2. it disables the X button so the users must exit by pressing the exit button.
Almost 100 users have the access to the database and it works fine for most of the users. but a few (4 or 5) users can't access it. when they try to open it receive the following error message:
"The operation on load you entered as the event property setting produced the following error: The operation on the | Object failed"
* the expression may not result in the name of a macro, the name of user-defined function, or [event procedure].
* there may have been error evaluating the function, event or macro.
i have checked the rights of the users to that drive and they have all the necessary rights. there is nothing changed as well as the database is concerned.
can any body help me please
regards
Ali
i have developed an access database and i have multiple users accessing the database at the same time. For this i have splitted the database in front end and back end. Because i am not in IT department therefore i can't put back end on to the server and install front end on individual's PC. what am i doing is that i have put both the back end and the front end in a shared drive, so the users can access it from there.
my login form does the following tasks on load
1. captures the network user name of the user and compares it with the database if the user exists it allows the user to open their relevant tasks.
2. it disables the X button so the users must exit by pressing the exit button.
Almost 100 users have the access to the database and it works fine for most of the users. but a few (4 or 5) users can't access it. when they try to open it receive the following error message:
"The operation on load you entered as the event property setting produced the following error: The operation on the | Object failed"
* the expression may not result in the name of a macro, the name of user-defined function, or [event procedure].
* there may have been error evaluating the function, event or macro.
i have checked the rights of the users to that drive and they have all the necessary rights. there is nothing changed as well as the database is concerned.
can any body help me please
regards
Ali
