Access a 'remote' Access DB through ADO

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

    Access a 'remote' Access DB through ADO

    I have an intranet-based app that links to an Access DB. It works fine on my
    developement machine, but if I place the DB on a different server, I have
    problems - the JET Engine (ADO) complains that the DB is "...already opened
    exclusively by another user, or you need permission to view its data."

    Connection Strings:
    Application("Co nnection") = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
    Source=c:\mydb. mdb"
    Application("Co nnection") = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
    Source=\\server \dir\mydb.mdb"

    The first works, the second doesn't.

    I'm not entirely surprised at this, but I'm wondering if there are any
    tweaks or workarounds?
    I'm assuming it is a permissions issue, but how can I give my IUSR (local)
    account access rights to a domain??

    Any suggestions?

    TIA

    Chris


    Tags: None
    • Aaron Bertrand [MVP]
      #2
      Re: Access a 'remote' Access DB through ADO

      http://www.aspfaq.com/2168


      --
      Aaron Bertrand
      SQL Server MVP
      http://www.aspfaq.com/





      "CJM" <cjmwork@yahoo. co.uk> wrote in message
      news:u3flXtI$DH A.2804@tk2msftn gp13.phx.gbl...[color=blue]
      > I have an intranet-based app that links to an Access DB. It works fine on[/color]
      my[color=blue]
      > developement machine, but if I place the DB on a different server, I have
      > problems - the JET Engine (ADO) complains that the DB is "...already[/color]
      opened[color=blue]
      > exclusively by another user, or you need permission to view its data."
      >
      > Connection Strings:
      > Application("Co nnection") = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
      > Source=c:\mydb. mdb"
      > Application("Co nnection") = "Provider=Micro soft.Jet.OLEDB. 4.0; Data
      > Source=\\server \dir\mydb.mdb"
      >
      > The first works, the second doesn't.
      >
      > I'm not entirely surprised at this, but I'm wondering if there are any
      > tweaks or workarounds?
      > I'm assuming it is a permissions issue, but how can I give my IUSR (local)
      > account access rights to a domain??
      >
      > Any suggestions?
      >
      > TIA
      >
      > Chris
      >
      >[/color]


        Comment

        • CJM
          #3
          Re: Access a 'remote' Access DB through ADO

          Thanks Aaron.

          "Aaron Bertrand [MVP]" <aaron@TRASHasp faq.com> wrote in message
          news:%23q7ad2I$ DHA.3816@TK2MSF TNGP09.phx.gbl. ..[color=blue]
          > http://www.aspfaq.com/2168
          >
          > --
          > Aaron Bertrand
          > SQL Server MVP
          > http://www.aspfaq.com/
          >
          >[/color]


            Comment

            Previous template Next
            Working...