# Asp database connection

**URL:** https://forum.kirupa.com/t/asp-database-connection/223558
**Category:** Uncategorized
**Created:** [April 23, 2007, 10:01pm UTC](https://forum.kirupa.com/t/asp-database-connection/223558 "2007-04-23T22:01:44Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![dirksmith](https://avatars.discourse-cdn.com/v4/letter/d/47e85d/32.png) [@dirksmith](https://forum.kirupa.com/u/dirksmith)
#### Post date: [April 23, 2007, 10:01pm UTC](https://forum.kirupa.com/t/asp-database-connection/223558/1 "2007-04-23T22:01:44Z")

</div>

Hi everyone,

I hope someone here can shed some light onto a situation which I have encountered during development of a website which I inherited (I _hate_ inheriting other people’s work!).

I’m somewhat new to Windows servers and ASP - more of a Linux and PHP man _ducks for cover_

I got given the site below to complete:  
www dot horse-quest dot com

I know it looks like a dogs dinner, that’s besides the point.

The site gathers a lot of its page content from a Microsoft Access database using ADODB / Jet (I think thats right).

What is occuring is that every now and again when parts of a page go to connect to the database to retrieve data, the following error occurs:

“Microsoft JET Database Engine error ‘80004005’  
Could not use ‘’; file already in use.  
/includes/connections.asp, line 35”

All open connections to the database are closed, and the ASP code is as efficient as I can get it using common logic and object orientation.

Can someone explain to me why this error is occuring so often please? I mean, is it a server configuration setting? Does it only allow x amount of connections at one time? Should I upgrade the site to a MSSQL database?

Many thanks in advance,  
Dirk