DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Using Inner Join with a Linked Table (Error Message).

  1. #1
    Frixos Kimonis Guest

    Using Inner Join with a Linked Table (Error Message).

    I've created a file DNS entry to a database (password protected Access 97)
    on my IIS server and am using ASP to connect, do an SQL query and return
    records into a recordset.

    If the query returns records from a table in the db there are no problems.
    ##
    ' -- Connection String Value
    strConnection = "FILEDSN="suppliers.dsn"

    ' -- Open the Connection
    objConn.Open strConnection, , <password>

    ' -- Our SQL Statement
    strSQL = "SELECT * FROM [Actions] WHERE [Actions].[Order Number] = " &
    SearchNumber

    ' -- Populate our Recordset with data
    set objRS = objConn.Execute (strSQL)
    ###

    BUT My main database also includes a table linked from another database.
    When I attempt to do an inner join with the linked table I get an error :

    ##
    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
    cannot open the file <name of db where linked table is from>. It is already
    opened exclusively by another user, or you need permission to view its data.
    ##

    How do I gain access to the linked table?

    Thanks

    Frixos










  2. #2
    Matthew Guest

    Re: Using Inner Join with a Linked Table (Error Message).


    Frixos,

    I had the same problem and spent two days trying to get it to work. I finally
    gave up and moved the queries to the source database - which was a doable
    thing for me, but certainly may not be for you!

    The interesting thing is that my VB Components (when called from a VB Client)
    will achieve this result with no problems whatsoever. But as soon as you
    involve IIS - it does not work. I'm sure it has something to do with NT permissions
    and IIS's security context - but I was not able to figure it out. Does anyone
    out there know the solution to this? I'm dying to know!
    Granting permissions to IUSR_machinename is <b>NOT</b> the answer.


    "Frixos Kimonis" <fkimonis@theclancyrgoup.co.uk> wrote:
    >I've created a file DNS entry to a database (password protected Access 97)
    >on my IIS server and am using ASP to connect, do an SQL query and return
    >records into a recordset.
    >
    >If the query returns records from a table in the db there are no problems.
    >##
    >' -- Connection String Value
    >strConnection = "FILEDSN="suppliers.dsn"
    >
    >' -- Open the Connection
    >objConn.Open strConnection, , <password>
    >
    >' -- Our SQL Statement
    >strSQL = "SELECT * FROM [Actions] WHERE [Actions].[Order Number] = " &
    >SearchNumber
    >
    >' -- Populate our Recordset with data
    >set objRS = objConn.Execute (strSQL)
    >###
    >
    >BUT My main database also includes a table linked from another database.
    >When I attempt to do an inner join with the linked table I get an error

    :
    >
    >##
    >Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    >
    >[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine
    >cannot open the file <name of db where linked table is from>. It is already
    >opened exclusively by another user, or you need permission to view its data.
    >##
    >
    >How do I gain access to the linked table?
    >
    >Thanks
    >
    >Frixos
    >
    >
    >
    >
    >
    >
    >
    >
    >



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