ASP and Ms Access Problem

[patelajk]

Hi guys

I trying to create a dynamic combo box in Dreamweaver, I have made a
connection to the database and created a recordset and mapped the recordset to
the combo box.

When I run the page it works fine the box has the the right content. However
if i exit the page and try to run it again I get a message saying the database
has been opened by another user and when I go to the location of the database I
can see that the database is locked, just as if someone else is accessing it. I
have to restart mu pc in order to kill the connection,

I am using MS Access and ASP - VBscript, I am closing the recordset, does
anyone know what i am doing wrong, do i have to close the datbase connection
and if so how do i do this.

Any help would be great, thanking you in advance

[CarlGrint]

Have a read of Jule's The infamous 80004005 errors article

[url]http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=56[/url]


Originally posted by: patelajk
Hi guys

I trying to create a dynamic combo box in Dreamweaver, I have made a
connection to the database and created a recordset and mapped the recordset to
the combo box.

When I run the page it works fine the box has the the right content. However
if i exit the page and try to run it again I get a message saying the database
has been opened by another user and when I go to the location of the database I
can see that the database is locked, just as if someone else is accessing it. I
have to restart mu pc in order to kill the connection,

I am using MS Access and ASP - VBscript, I am closing the recordset, does
anyone know what i am doing wrong, do i have to close the datbase connection
and if so how do i do this.

Any help would be great, thanking you in advance