Re: Problems accessing an MS Access 2000 DB in ASP

• Previous message: Brad Pears: "Problems accessing an MS Access 2000 DB in ASP"
• In reply to: Brad Pears: "Problems accessing an MS Access 2000 DB in ASP"
• Messages sorted by: [ date ] [ thread ]

Date: Wed, 21 Jul 2004 16:39:42 -0400

Brad Pears wrote:
> Our graphic designer is developing our new company website. We have
> switched providers and currently she is working on the new website
> which currently ressides on the new providers server as they support
> the ASP development environment. Their server is a Win2K3 server.
>
> She is writing an ASP module to connect to an MS Access 2000 database
> and is having problems connecting. In this database there is only one
> table.
>
> She has tried many different connection strings all to no avail and
> then found from investigating that the best and fastest method is to
> use the OLE connection string. However, each time she runs the ASP
> code she gets the following error...
>
> --------------------------------------------------------------------------

--
> --------
> Microsoft JET Database Engine error '80004005'
>
> You do not have the necessary permissions to use the
> 'E:\Files\LocalUser\truenorth\NewFiles\models.mdb' object. Have your
> system administrator or the person who created this object establish
> the appropriate permissions for you.
>
> /NewFiles/db_simple2.asp, line 14
> --------------------------------------------------------------------------
--
> --------
>
> We have asked the provider to make sure that the NTFS file privs have
> been set appropriately on the directory this db is in, and they have
> informed us that it has been.
The IUSR_machinename account needs read/write permissions on the folder
containing the database file. If you are connecting in a Session or
Application event, or the application protection is set to high, then the
IWAM_machinename account also needs those permissions.
The person setting up the security for your database can verify that the
appropriate permissions are set by logging into the machine using the IUSR
account and verifying that he can create and delete a text file in the
database folder.
Bob Barrows
-- 
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

• Previous message: Brad Pears: "Problems accessing an MS Access 2000 DB in ASP"
• In reply to: Brad Pears: "Problems accessing an MS Access 2000 DB in ASP"
• Messages sorted by: [ date ] [ thread ]