
PowerPoint Presentations based on Access Databases.
Hello All,
Im still struggling with a problem of hooking PowerPoint Presentations Up to
Access DataBases via PowerPoint
VBA Macros. I have read the KB articles
titled "Sample VB Code Uses DAO to Create Presentation","How to Fill MS VB 5.0
Flex Grid Controls" and "How to Fill A UserForm ListBox with DataBase
Values"...... But, Whenever I try to run the KB codes I get an error that
says "Can't Start your Application. The workgroup information file is missing or
opened Exclusively by another User." or "Missing Parameter. Expected 3" As near
as I can tell, these codes are all short one key component in connecting to my
database(s): I need to pass WorkGroup information (like DataSource and System
DataBase). I have done this in VB 6 but have no clue how to do it in VBA for
PowerPoint. The closest I have gotten is the following:
Set oWorkSpace= CreateWorkSpace(Name="JetWorkSpace", UserName= "MyName",
Password= "MyPassWord", UseType:=dbUseJet)
Is there some other Parameter that needs to be put in the above... Like
maybe "SystemDatabase = C:\Database\System.mdb" (I tried this and it didn't work)
Thanks In Advance for any assistance.