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?
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.
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.
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!