Re: Access Databases & IIS 6.0
- From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxx>
- Date: Fri, 28 Apr 2006 16:30:26 +0100
Gary wrote on Fri, 28 Apr 2006 05:58:01 -0700:
Hello,
I administer a Windows Server 2003 running IIS 6. I also administer
multiple web sites that are hosted on this server. One of the end-users
maintains some Access databases that are contained in one of the virtual
webs. He gets the following error message from time to time:
Unable to establish connection to database.
Error information:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file
'\\xx.xx.xxx.xxx\nos\ecc\ERETS_V3\db\ERETS.mdb'. It is already opened
exclusively by another user, or you need permission to view its data.
Other possible cause of this problem:
The database cannot be opened, most likely due to incorrect connection
settings or insufficient security set on your database folder or file.
For more details please refer to
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q306518
I have found that rebooting resolves this problem as it is usually memory
that is not reallocated or hung by the process but, this is not a good
solution as it is a server and other webs are hosted. I have also solved
some memory allocation/process problems by going to task manager and
selecting 'Inetinfo.exe' and ending that process but that resolution does
not work in this instance.
Can anyone advise me what service an .MDB file is using so that I can
perhaps stop and restart this service in lieu of the reboot?
When I used to use Access databases on my sites, this message normally
appeared when someone had opened the database in Access itself to make some
changes. However, it's also likely to be caused by having too many
connections at once - Jet is not designed for more than a few simultaneous
users. I'd recommend you find a way to upsize this to SQL Server - you can
use SQL Server 2005 Personal Edition which is free.
Dan
.
- Prev by Date: Re: Access Databases & IIS 6.0
- Next by Date: Re: Muliple Websites on Mutliple IP address with certicles [SSL]
- Previous by thread: Re: Access Databases & IIS 6.0
- Index(es):
Relevant Pages
|
