I am having a problem with linked databases and ASP... I have a master.mbd database on a server and computerinfo.mdb with links to master.mdb copied to all the clients. This part works fine, but I have a asp page that displays some info that points to its own copy of computerinfo.mdb and works fine if no one is in thier copy of the database. The asp code that opens the database looks like this...

set conn=Server.CreateObject("ADODB.Connection&#34
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("./data/computerinfo.mdb&#34)
set rs = Server.CreateObject("ADODB.recordset&#34
rs.Open "Select * from ComputerInfo", conn

If someone has thier own local copy of computerinfo.mdb open then the page cannot be displayed and says that master.mdb is open. I was just curious if the asp page needs exclusive rights to the database in order to open it, or if this is even possible.

Thanks,
Landon.