Lectora to Access CGI Script
April 6, 2009 12:00 AM
Hmm, it sounds like you might be able to pull this off without having to install IIS on each machine. When you check with your IT department, see if there is a way for you to upload and use an ASP page (I'll give you an 'ASP classic' script, as this will require the min IIS requirements to run).
Here is a quick rundown of your end configuration as I see it:
User connects to server where database and course information is hosted to take the course
At the end of the course, your scores and information will be sent to an ASP classic page
The ASP page will post the information to your database.
A few notes about your database:
Should be password protected.
If you think you will have more than 20 concurrent users (using it at the same time), you should consider a SQL database. Access databases only allow one connection at a time. The connections are very fast, but if more than one user just happens to hit 'Complete' at the exact same time. Someone will win, and the others will fail to connect. Sounds scary, but if you have a fairly small implementation, this will almost never happen. Our old software ran on Access Database for years. We almost never saw this issue.
However, if your concerned because you have a lot of concurrent users, and if your IT department will allow for you to create/own a SQL database on the server. This would be ideal. But the learning curve for a SQL Server is somewhat stiffer than for Access.
I usually deal with SQL server, but I will take a look back at some of my past AccessDB connection strings and see what I come up with. Let me know when you hear something.
Discussions have been disabled for this post