Problems closing a database...

Morning lads... I'm having a strange problem with one of me databases - When I load a page of the website, it displays some of the entries from the database, when I open a different page, it opens different entries, and so on...

It works fine when I open a the first page, but when I try to open another page, I get "Provider error '80004005' Unspecified error". If I wait about a minute then refresh, it works ok.
I tried watching the Access database while I was using the website, and saw this... when I opened the first page, the file drBooze.ldb was created, but not deleted. Isn't this file only supposed to exist while the db is in connection with the website?

I have

rsDrBooze.Close
adoCon.Close
Set rsDrBooze = Nothing
Set adoCon = Nothing

at the end of my html code, so the .ldb file should be deleted, but it's not!
Have I not closed the connection properly, or is this not the problem?
Cheers...

morning ChiefWigs1982,

i don't think your ldb is your problem. Your drBooze.ldb exists because you opened it with your Access, if you close your Access database, then the drBooze.ldb would disappear.

I think you *opened* one of your tables in drBooze.mdb while accessing it with your internet browser.

if my above still does not work, then you better read this.

- http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=115
- http://www.skybuilders.com/Users/Je...Access2000.html

Hi pda. Dunno what's going on here, but I've tried the site out again this morning, and everything is working fine!

It seems the remote server it's on was just being a bit temperamental! Thanks anyway!

Probably an overstressed web server. Access and the Access data drivers are not particularly scaleable and this type of error can pop up intermittently when the server is running low on resources for data connections.