Hi, all.  I'm running a summer IT camp for 20 bright 10th graders.  We are teaching them DNN and want to have them create a "job board for kids" website in which they link to an existing Access database (managed by a local non-profit charity).

We are very much novices at DNN. Can somebody please provide a step-by-step "how-to" showing how to incorporate an existing Access database into a new DNN project site, create the input form that will write to the Access database, and then pull data from the Access database into a straightforward report?

We really need the coaching and step-by-step advice.  Can some kind DNN soul help us?

Thanks,

Doug Arthur

Program Coordinator

INTERalliance of Greater Cincinnati

doug.arthur@atosorigin.com

the best way to do this in an educational situation is to use aprogram like MyGeneration to build the database access and the Business level for the access database. Once that is done then you can build the module to display/edit or what ever you require - it also allows you to build a module that will interface to any version of DNN that you might want to use - the access database level is seperate from the DNN data providers etc so it is possible to run a access based module in say DNN3.

You can pickup MyGeneration free off the internet and you should also find templates for dodads that use the access database. This will not teach them about the DNN data providers but as an introduction into coding for DNN the dodad technology is ideal - once they get their modules working using dodads then extend the course into the more some what complex area of DNN data providers - however remember that from version 3 onwards there is no access database providers in DNN. There are MyGeneration templates for true DNN modules however they are all for SQL database.

If you email me and tell me what the schema of the database is I should be able to generate the data base level code for you using MyGeneration - however it is fairly simple to do if you download the software and the relevent dodad templates

John

does not give much time however if you can send me the schema I shall see what I can do for you. send it to my general email address baa@oziweb.net.au also can you tell me at what level of programming skills are these kids, what version of DNN have you got Please not version4 - suggest if you are teaching about DNN start them on DNN2.1.2 first (much easier to compile etc and less complex to teach) moving the dnn2 module to dnn3 is fairly easy if you need to do this later. Give me a fairly detail overview of what you want the kids to do please.