I have an MS Access database (Access 97). It is on a Network drive and the idea is multiple users (atleast 10) will be using it parallelly. I mean to input data/edit data.
When I am a user and other users in my department use, there is no error. But downstream department users use the database, it says the database is opened exclusively and can't open the database.
What should I do? I made sure that the database is opened in Shared mode and not exclusively. should all the users of this database should have same access rights to the network drive?
Any suggestions please.
thank you
nath
When I am a user and other users in my department use, there is no error. But downstream department users use the database, it says the database is opened exclusively and can't open the database.
What should I do? I made sure that the database is opened in Shared mode and not exclusively. should all the users of this database should have same access rights to the network drive?
Any suggestions please.
thank you
nath