Results 1 to 8 of 8

Thread: Why no work?

  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Why no work?

    I use this line to connect at a server:
    <%
    Set objCn = Server.CreateObject("ADODB.Connection")
    Set objRs = Server.CreateObject("ADODB.Recordset")

    With objCn
    .CursorLocation = adUseClient
    .ConnectionTimeout = 15
    .CommandTimeout = 30
    .ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=GCD01F4500DATIPUBBLICABOUASSPROVA.MDB; User Id=admin; Password=;"
    .Open
    End With

    I recieve this:

    Tipo di errore:
    Microsoft JET Database Engine (0x80004005)
    Il modulo di gestione di database Microsoft Jet non

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Why no work?

    Do you happen to have the database open in Access at the same time? If so, close the database in Access, then try again.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Why no work?

    Hi , Hans, and good evening...
    Dubt:
    BecausE when i use a VBA native (see my old post with L0785_DEF xls+CCESS) is possibl to use in simoultanius mode and with many user this mdb it can read, write, delete record ecc... and why when i invoque this same mdb with ASP page i have this error?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Why no work?

    It should be possible to open several connections to the database, but if someone (you?) opens the database in Access and opens an object in design view, the database will be locked. That is why I asked in my previous reply whether you had the database open in Access while testing the ASP code. You haven't answered that question.

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Why no work?

    .... hummm
    but when i use my old project L0785_DEF xls+access (remeber i distribute to many user the same wbbok) one of all of user can: with your wbook open the connection of mdb databse and can red, write ad up date the mdb from the wbbok???!!!!!

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Why no work?

    There is a difference between opening a connection to a database in code, and opening a database "manually", in particular if you then open a database object in design mode - something you cannot do through an ADODB connection.

  7. #7
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Why no work?

    I Hans i am bak on this problem...
    When i start the ASP page with the connection that point in another server of my lan farm and i have see in the dir where the mdb is stored i dont see the tipical icon .ldb.
    Why the script work with a native VBA and not in ASP?
    Big the big problem..

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Why no work?

    I don't do ASP, so I don't know much about this. The account used by IIS (usually IUSR) must have modify permissions (read/write/create/delete) on the folder containing the database, otherwise Access may not be able to create the .ldb file. Since Access uses the .ldb file to keep track of who is using a database, it must open the database exclusively if it can't create the .ldb file.

Posting Permissions

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