Hello,

I have recently undertaken a project in powerpoint 2007 to create an
interactive lecture and I have encountered some problems.

What im trying to do is build an interactive lecture, where students
register their student number at the start, which upon submitting is
saved to a database, then at some point in the lecture a question will
be posed to the students in the class, and using a voting pad on the
powerpoint slide via VBA buttons they can answer the question, and
their answer will be recorded in the database next to their name.

The problem im having is that I cant seem to find a way of connecting
powerpoint to a database, Ive been trying the ADODC control to try
connecting to a simple access mdb file but due to changes in the VBA
in Office 2007 it doesnt seem to like it. It doesnt even allow for a
data connection from text boxes.

Do you know of a way that I could connect my presentation to a
database? Even an online database? Ideally I want to chuck all the
students answers in their and then have them download into a graphical
format, but at the moment I cant seem to connect it to a database!

I would really appreciate any reply you could give me!

In article <d174c35a-951f-4a1b-adca-
9660ac48d545@h9g2000yqa.googlegroups.com>, Nickooo87 wrote:
> Hello,
> 
> I have recently undertaken a project in powerpoint 2007 to create an
> interactive lecture and I have encountered some problems.
> 
> What im trying to do is build an interactive lecture, where students
> register their student number at the start, which upon submitting is
> saved to a database, then at some point in the lecture a question will
> be posed to the students in the class, and using a voting pad on the
> powerpoint slide via VBA buttons they can answer the question, and
> their answer will be recorded in the database next to their name.
> 
> The problem im having is that I cant seem to find a way of connecting
> powerpoint to a database, Ive been trying the ADODC control to try
> connecting to a simple access mdb file but due to changes in the VBA
> in Office 2007 it doesnt seem to like it. It doesnt even allow for a
> data connection from text boxes.
> 
> Do you know of a way that I could connect my presentation to a
> database? Even an online database? Ideally I want to chuck all the
> students answers in their and then have them download into a graphical
> format, but at the moment I cant seem to connect it to a database!
> 
> I would really appreciate any reply you could give me!

Have a look on the PPTFAQ at http://www.pptfaq.com/

Search on "Access" or on "Reilly" or "Nichani"

Brian Reilly and Naresh Nichani wrote several articles (including code 
examples) that explain how to move data from Access to PPT.  I don't 
imagine it'd be too hard to reverse the flow.



==============================
PPT Frequently Asked Questions
http://www.pptfaq.com/

PPTools add-ins for PowerPoint
http://www.pptools.com/