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
Doh! I may have typed too soon. The function I referenced was authored by Susan Sales Harkin in the November 2000 issue of Inside MS Access, and, as such, is copyrighted. Her article details how to use an ADO schema recordset to fetch a list of users with a database open. My apologies! You might contact the nice folks at 
