Network Authority to DB

[David777]

Hello,

I have a database that located on a network. I have several child replicas that only certain persons can access. The main database, everyone has all rights to. The child only the person allowed to have access has rights to. We keep getting the message that the database is already in use, when a second persontries to get into the database. Does anyone have any suggestions that might help?

Thanks,

David

 

[freakazeud]

Hi,
you HAVE to split your db into frontend and backend in a multi user environment. Normally every user gets a copy of the frontend on their local machine and these link back to ONE backend on the server.
You can read a lot more about this here: discussion
HTH
Good luck