connection issue

I am using ADO to open connection

my connection string is

"Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"

I have a web page that opens the above connection.

I opened mydatabase.mdb in exclusive mode in MS Access and did some
modifications and then hit my page (which
opens the mydatabase.mdb using above connection) generates the
error....Which is correct as Exclusive mode locks the DB and my web page
doesnt get the connection thru due to the lock....Now I closed the MS Access
and hit my page it works for couple of hits and afterwards I get the same
error I used to get when Access was Opened in Exclusive mode....

the code is in VB component. I am accessing this function from asp page. I
have a display button on my asp page which when clicked ultimately runs the
above piece of code from VB comoponent. If I quickly press Display it works
but for successive cliks on Display button this code returns me "Unspecified
Error"

code snippet is

------------------------------------------------------------

If strConnString <> "" Then
Set conn = New ADODB.Connection
conn.Open strConnString
Set rsOutput.ActiveConnection = conn
rsOutput.CursorLocation = adUseClient
Set rsOutput = conn.OpenSchema(adSchemaColumns, Array(Empty,
Empty,tmpStrTable, Empty))
Set rsOutput.ActiveConnection = Nothing
conn.Close
Set conn = Nothing
End If

Set MyFunction = rsOutput.Clone

------------------------------------------------------------

there is somethisng when Access file is opened in exclusive mode and hit the
asp page.....

any help is appriciated....

thanks


.