SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Addict djh's Avatar
    Join Date
    Apr 2000
    Location
    Long Beach, CA
    Posts
    333
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi all,

    I'm using the poll script from 4guysfromrolla with an Access 2000 db. I'm getting the error "File Already in Use" when two or more simultaneously try to vote on the poll. Is there a way to circumvent this or do I have to stop using Access?

    With all the PHP hoopla flying around, maybe I should go with mySQL and PHP eh?

    Thanks folks...
    <BLOCKQUOTE><font size="1" face="Verdana, Arial">code/font><HR><pre>
    Server.CreateObject("ADODB.Connection")
    newConn.ConnectionString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & _
    [/code]

    ------------------
    Dave Han - webmaster@goboatingamerica.com
    If a question can be put at all, then it can also be answered."
    Visit goboatingamerica.com

  2. #2
    SitePoint Zealot
    Join Date
    Feb 2000
    Location
    MI
    Posts
    166
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What language are you currently using with the Access database? I'm working on perfecting my PERL/MySQL skills.

    Richard

    ------------------
    richard@brevig.com

  3. #3
    SitePoint Addict djh's Avatar
    Join Date
    Apr 2000
    Location
    Long Beach, CA
    Posts
    333
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'm using vbscript...the language of choice for ASP.

    Have you encountered similar woes?

    ------------------
    Dave Han - webmaster@goboatingamerica.com
    "If a question can be put at all, then it can also be answered." - Wittgenstein
    Visit goboatingamerica.com

  4. #4
    SitePoint Zealot
    Join Date
    Feb 2000
    Location
    MI
    Posts
    166
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I don't use that program(ing language). However, the other day I had to trouble shoot for 20-45 minutes when accessing a MySQL database (with perl). It turned out I was trying to access the name of the database with the name of the server.

    Edits are noted by ().

    Richard

    ------------------
    richard@brevig.com

    [This message has been edited by richjb (edited August 07, 2000).]

  5. #5
    SitePoint Addict djh's Avatar
    Join Date
    Apr 2000
    Location
    Long Beach, CA
    Posts
    333
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I guess all you guys are so taken with PHP that ASP questions are now left to... well the likes of me.

    I just have a simple question, as state before. I keep getting a "File already in Use" error from my ASP homepage that's tied to a simple poll database.

    Is it a constraint unique to Access, where simultaneous users cause it to go haywire, or is there something wrong with the script? (The script is the same as the poll script from 4guys).

    Thanks...

    ------------------
    Dave Han - webmaster@goboatingamerica.com
    "If a question can be put at all, then it can also be answered." - Wittgenstein
    Visit goboatingamerica.com

  6. #6
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    We're not all PHP'ers. We've got some resident ASP experts here, too. Hopefully one of them (Wayne?) can propose a solution. If not, you might want to email the author of the tutorial you're following to see if he or she has any pointers.

    ------------------
    -Kevin Yank.
    http://www.SitePoint.com/
    Helping Small Business Grow Online!

  7. #7
    SitePoint Wizard
    Join Date
    Apr 2000
    Posts
    1,483
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I know ASP...although I think your problem is with Access and not ASP.
    MS Access doesn't support two or more simultaneous writes. So you have to either only allow one vote at a time or use something like mySQL or MS SQL Server.
    Hope that helps!


Bookmarks

Posting Permissions

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