Article ID: 169271 - Last Review: June 22, 2005 - Revision: 2.1 Err Msg: Database Already in Use with MS Access Database on Remote ShareThis article was previously published under Q169271 We strongly recommend that all users upgrade to Microsoft Internet Information Services (IIS) version 6.0 running on Microsoft Windows Server 2003. IIS 6.0 significantly increases Web infrastructure security. For more information about IIS security-related topics, visit the following Microsoft Web site: http://www.microsoft.com/technet/security/prodtech/IIS.mspx
(http://www.microsoft.com/technet/security/prodtech/IIS.mspx)
SYMPTOMS
When you try to use a Microsoft Access database with Internet
Information Server (IIS) where the database is located on a remote
share, you may get the following error message:
Database already in use
CAUSE
This error message is actually caused because the connection is
denied access to the share.
WORKAROUND
Create an account on the server that contains the share for the
Microsoft Access database that matches the IUSR account on the
IIS server.
For example: IIS Server user account = IUSR_IISBOX Remote server: Create an account called IUSR_IISBOX and make sure the password matches the IUSR_IISBOX account on the IIS server. If necessary, change the password on both accounts so they match and remember to change the password in the Internet Service Manager on the IIS server to match. | Article Translations
|
| United States | Change | | | All Microsoft Sites |
Back to the top
|
