I think I posted this in wrong place before.. maybe try here.
thanks in advance with this one anyone,

Hi

I need urgent help. I cant get my hosting to resolved it.. says
if it was a simple problem it would of been fixed? says the database
is in full control but if more then one person accesses or
I open 2 connections it fails.

it was all working fine before the WIN2000 with sql97 and MDB
access was upgraded to a WIN2000 with a separate sql2000 server box
and a faster web server box

<%
'using the newer open methods to MDB
response.write "This should work, multiple access (opens) to a MDB<br>"


Set objConn2 = Server.CreateObject("ADODB.Connection")
objConn2.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\stats\data.mdb")

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\stats\data.mdb")

'do nothing just a simple open and close


objConn.Close
Set objConn = nothing

objConn2.Close
Set objConn2 = nothing

response.write "MS ACCESS MDB - multiple opens to the same DB Successful!<br>"
%>

ERROR given as follows
Microsoft JET Database Engine error '80004005'

Could not use ''; file already in use.

/multimdbtest2.asp, line 10


this is a simple ASP for testignonly the real code does 2 connections
and worked fie for 12 months on a older server setup.. so I dont think
its anything to do with coding after that fact.

ANY CLUES ANY ONE?