Results 1 to 3 of 3

Thread: Code Error

  1. #1
    Join Date
    Nov 2005

    Unanswered: Code Error

    I am trying to access MS-Access Database on a remote server with the code below.

    <!--#INCLUDE virtual="/common/pricelist.asp"-->
    Dim ConnectionString
    dim oConn

    ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)};" &_
    "DBQ=\\Server167\BusOps\Maint_ Ren_ Web_ Page_ Upload_DB.mdb;DefaultDir=;UID=;PWD=;"

    Dim objRS
    Set objRS = Server.CreateObject("ADODB.Recordset")
    objRS.Open "Select * from [Maintenance Renewal RAW Report] where country = 'AD'", ConnectionString


    and it gives me the following error.

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'

    [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

    /Renewals/testfeb.asp, line 13

    please suggest, how should I reslove it.

  2. #2
    Join Date
    Nov 2005
    Honolulu HI
    does your provider allow remote database access ? are you accesing this from another website ?

    i know we dont allow remote access from outside of our servers.
    you have to be within the same account to access a database.

    your provider might have it blocked
    Providing Technology services to non profit orgs, Homeless Shelters, Food Pantries, Clean And Sober Houses and more.
    To date we have given away over 900 free computers !
    caeli enarrant gloriam Dei !

  3. #3
    Join Date
    Jun 2003
    And perhaps not a high chance of success but you may want to check this out:

    Why can't I access a database or text file on another server?
    J. Paul Schmidt, Freelance Web and Database Developer
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts