Force Access database to close from web site

[Ariana]

Hello all,

I am using an Access database as the data source for a ASP.Net dataset
created in Visual Studio 2005. The web site is hosted by an ISP.

The problem is that I can't overwrite the Access database when I need to
replace it with a more recent copy. Presumably, it is open as long as the
web site is running, but is there any way to force it to close long enough
to upload it? (given that I don't have any means of stopping or starting the
web site as a whole, and that the data set is generated by Visual Studio)

Thanks!

 

[JIGNESH]

If DB connection object is closed and Disposed properly then it should not
remain open. anyways try deleting bin folder(if deployed in classic 1.1
style) OR override web.config file with some changes. changing web.config
should restart your application. then you should be able to replace DB.

Regards
JIGNESH.

 

[Scott M.]

I've never had a problem replacing an Access DB on my web host. Are you
sure you are correctly closing your connection?