below is my databse connection .<BR>dim con,rs<BR>&#060;%set con=server.createobject("adodb.connection")<BR>con .open"provider=microsoft.jet.oledb.4.0;data source=\mach1emp1emp.mdb"<BR>set rs = server.createobject("adodb.recordset")<BR> "select * from tab1 where id=" & so and so.<BR>%&#062;<BR>now i preview the page in browser. it gives the following errorError Type:<BR>Microsoft JET Database Engine (0x80004005)<BR>The Microsoft Jet database engine cannot open the file &#039\mach1emp1emp.mdb&#039. It is already opened exclusively by another user, or you need permission to view its data.<BR><BR>well strenge thing after an hour it work fine. but almost most of the time it gives this error.<BR>is there any prob. with jet engine on the server.or with connection,since i use dsn-less connection.<BR>please help .<BR><BR>