Access DB and "File Already in Use" error...

[djh]

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

[richjb]

What language are you currently using with the Access database? I'm working on perfecting my PERL/MySQL skills.

Richard

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

[djh]

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

[richjb]

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).]

[djh]

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

[Kevin Yank]

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!

[James]

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!