Solving MS Access Concurrency

[Guest_imported]

I'm writing a market research style questionnaire application in ASP /ADO using Access as a backend. Each asp page is a different question, and some of the answers can be up to 3000 chars. I've heard that Access is unreliable with more than 10 concurrent users so instead of opening a connection to Access in every page, I plan to hold all the users' answers in cookies and session variables until the last page, and then open up a connection to Access and post all the answers in at once.

Is this likely to solve the problem, or will it just create new ones? At what point do we stop using Access and start looking for SQL Server solution?

Many thanks

Alex

 

[DougP]

Yes SQL is your best bet.
It can hold large amounts of data and its not that difficult to learn or use.
I have our SQL server right next to my programming Work Station and if I need to create SQL code I open Enterprize Manager.
Then I can open a table and use their QBE type grid to drag and drop columns and let it build the SQL.
Then I copy the SQL code to the clipboard and save it in a Notepad txt file to a shared drive then paste it in my PC in ASP
It works Great.
3 months ago I could spell ASP or SQL and now I love it better than Access.

DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.