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.