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


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

Set objConn = nothing

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.