Lectora to Access CGI Script
April 6, 2009 12:00 AM
Mike:
I would suggest against using multiple databases. This will almost always cause issues later down the road when you want to consolidate information.
According to your numbers, you should use a SQL database. SQL Server Management Studio Express is free. Using SQL, unfortunately, will take more involvement with your IT department. They will have to create a SQL database on the server for you and give you a login for you to access it. But this will give you the scalability you need and is much easier to work with from a code standpoint.
The next thing you need to think about is the structure of your database. Put together a list of all of the information you want this database to capture per record. Name, Score, Company, Location, Course, Fail/Pass, etc. How many courses do you have? How many different companies/locations do you have? Etc, Etc, Etc... everything. Post that list, and I'll try and help you normalize your information. Keep in mind that Lectora will have to pass a variable for each bit of information you store.
Keep me updated, Davin
Discussions have been disabled for this post