I have several modules inside this database. They are used to run periodic routines. At same time I have a Visual Basic application that access that database.
I updated the mdb file from version 97 to 2000. After this change, some problems started to happen.
Now, when a user opens the mdb file (putting login and password through a mdw file) and try to change a line of a module, the following message appears:
"You dont have exclusive access to database nowadays. If you continue doing changes, they probably wont be saved after."
But before, in version 97, the users could change the code and execute it. Its necessary because the user has to be able to handle the code when a exception occurs.
I cant give exclusive access to a user because the database is sharing for fifty people at same time. If someone open the database in exclusive mode to run a module, all the department stops.
I searched the help of Access 2000 but I didnt find anything about it.
What can be it?