Access remote access database from ASP

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • william
    #1

    Access remote access database from ASP

    Hi,

    I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:\Collect.mdb '. It is already opened exclusively by another user, or you need permission to view its data. ".
    The 'F:\' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.

    Could anyone tell me how to make it work?

    Thanks.
    william
    wcui@mfgsyscorp .com
    Tags: None
    • Jeff Cochran
      #2
      Re: Access remote access database from ASP

      On Tue, 10 Feb 2004 11:41:06 -0800, "william"
      <anonymous@disc ussions.microso ft.com> wrote:
      [color=blue]
      >I have an ASP page needs to access a remote MS Access2000 database, I got error "The Microsoft Jet database engine cannot open the file 'F:\Collect.mdb '. It is already opened exclusively by another user, or you need permission to view its data. ".
      >The 'F:\' is a mapped drive from remote machine where the access database loactes. If I copy the database back to local box, no problem.
      >
      >Could anyone tell me how to make it work?[/color]

      Proper permissions would likely do it. keep in mind that an ASP page
      isn't running under the same account you mapped the drive with. It's
      normally the IUSR account that needs the right permissions, and that
      account is a local account, not a domain one.

      Jeff

        Comment

        • william
          #3
          Re: Access remote access database from ASP

          Hi Jeff
          Thanks
          Could you give me some steps to make it

          willia


            Comment

            • william
              #4
              Re: Access remote access database from ASP

              Hi
              I created IUSER_SERVERNAM E on Domain with empty password, and grant this user full control permission on the folder where my access database locates on other machine, and I'm able to run my ASP to access the remote database, but when I try to run second time I got "Unspecifie d error" error( when the asp show up, it will go to remote database to get some data back and populate list box on the asp page, there is button on the page, on click event, it will query the database again)
              I use a DSN to access database

              Any idea

              Thanks

              willia


                Comment

                • william
                  #5
                  Re: Access remote access database from ASP

                  Hi
                  Can I use domain user id to access remote Access2000 database
                  I created IUSER_SERVERNAM E on PDC with password, grant this user full permission on the remote database folder, and setup to use this account on IIS\Properties\ Directory Security\Edit\A nnonimous Access\Edit, and uncheck the check box(allow IIS to control password). I got "...-[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides."

                  Any ideas

                  Thanks

                  william

                    Comment

                    • william
                      #6
                      Re: Access remote access database from ASP

                      Hi
                      From Event view, the error is "The server was unable to logon the Windows NT account 'IUSER_C2K-WHAM' due to the following error: Logon failure: unknown user name or bad password. The data is the error code.

                      thank


                        Comment

                        Previous template Next
                        Working...