Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    data to web page (97)

    Why do asp pages targetted at a database fail when the mdb file is open to an access user?

  2. #2
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data to web page (97)

    With IIS 5, MDAC 2.5 and Access 2000, I was able to do the following:

    Query a db using ADO and display results, with the db open (user = Admin) and with either the table in data sheet view or not open at all.

    Post a record using ADO to the same table with the same conditions.

    What kind of an error are you getting, what methodology are you using, what's the landspeed vel...well, you get the idea!
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data to web page (97)

    are you ready ?
    IIS4, MDAC2.5, Access97,ASP pages using MSADO1.5
    Wind speed 20 knots from the north....
    The error is from asp stating (in bright yellow) that the file is already in use [img]/forums/images/smilies/sad.gif[/img]

  4. #4
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: data to web page (97)

    I ran into this at the outset as well - it's a rights and permissions issue. Check <A target="_blank" HREF=http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP?LN=EN-US&SD=msdn&FR=0&qry=q183060&rnk=1&src=DHCS_MSPSS_m sdn_SRCH&SPR=MDAC>this</A> KB article for your exact message and circumstance. Yawp if none of them does the trick for you!
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

Posting Permissions

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