Problem opening Connection from ASP application


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Problem opening Connection from ASP application

Hybrid View

  1. #1
    Michael Z. Guest

    Problem opening Connection from ASP application


    Hello, everybody. My asp application needs to access an Access 97 Database
    located on the network. When the application tries to open an ADO connection
    to this database I receive the following error:

    Microsoft JET Database Engine error '80004005'

    The Microsoft Jet database engine cannot open the file '\\NYINTPROP\LEASE\lease.mdb'.
    It is already opened exclusively by another user, or you need permission
    to view its data.

    /Time7/global.asa, line 7

    I know the problem has something to do with permissions, because only certain
    users have permission priveledges to the share where this database is. Do
    you know what user account does IIS 4.0 use when it opens a connection to
    a database on the network and what additional rights it would need to be
    able to open the database successfully.

    Thanks to everybody in advance for help.

  2. #2
    Douglas J. Steele Guest

    Re: Problem opening Connection from ASP application

    IUSER_machinename needs to have Change permission (RWXD) on the folder where
    the Access database is located.

    --
    Doug Steele, Microsoft Access MVP
    http://i.am/DougSteele/


    "Michael Z." <yz64@aol.com> wrote in message
    news:3b0a8cac$2@news.devx.com...
    >
    > Hello, everybody. My asp application needs to access an Access 97

    Database
    > located on the network. When the application tries to open an ADO

    connection
    > to this database I receive the following error:
    >
    > Microsoft JET Database Engine error '80004005'
    >
    > The Microsoft Jet database engine cannot open the file

    '\\NYINTPROP\LEASE\lease.mdb'.
    > It is already opened exclusively by another user, or you need permission
    > to view its data.
    >
    > /Time7/global.asa, line 7
    >
    > I know the problem has something to do with permissions, because only

    certain
    > users have permission priveledges to the share where this database is. Do
    > you know what user account does IIS 4.0 use when it opens a connection to
    > a database on the network and what additional rights it would need to be
    > able to open the database successfully.
    >
    > Thanks to everybody in advance for help.




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center