howdy friends,
with my internship coming to an end it is fitting i need the forum for one last piece of help. We have created a database and placed in on the network dive to allow multiple users within the group to have access to it. there is a security issue because we only want 1 person at a time opening the database. if 2 users have the DB open at the same time huge problems could occur. is therre a way to limit the open privlege to only one at a time. i want to "lock" the file if it is already open. i have tried the exclusive seetting but it does nothing since the DB is on a local network drive on not on someones computer. we need 1 user access for a networkrd database, this has to be available. thanks for all the help.
Ed the intern
with my internship coming to an end it is fitting i need the forum for one last piece of help. We have created a database and placed in on the network dive to allow multiple users within the group to have access to it. there is a security issue because we only want 1 person at a time opening the database. if 2 users have the DB open at the same time huge problems could occur. is therre a way to limit the open privlege to only one at a time. i want to "lock" the file if it is already open. i have tried the exclusive seetting but it does nothing since the DB is on a local network drive on not on someones computer. we need 1 user access for a networkrd database, this has to be available. thanks for all the help.
Ed the intern