fhenreaux
asked on
Crystal Report: connected to Access 2007 with vb 2008
Posted: Sep 6, 2010 11:35 AM Reply
Hi
I'm facing a problem, I can't connect a CR2008 Report to an Access 2007 Database in an application written with VB 2008.
It works with an .mdb database but not with a .accdb database, and I need an accdb!!!!
Could you please, help me?
Here is my code:
report1.FileName = PathToReports + "\Reports\RPT1.rpt"
report1.Database.Tables(0) .Location = PathToDB & "\Database files\myDB.mdb" ==> If I specify the accdb, it doesn't work
report1.VerifyDatabase()
Thanks
Hi
I'm facing a problem, I can't connect a CR2008 Report to an Access 2007 Database in an application written with VB 2008.
It works with an .mdb database but not with a .accdb database, and I need an accdb!!!!
Could you please, help me?
Here is my code:
report1.FileName = PathToReports + "\Reports\RPT1.rpt"
report1.Database.Tables(0)
report1.VerifyDatabase()
Thanks
Please a screenshot with the error in question.
It is easier to create a dataset in your vb apllication from your access database and then work with the full dataset in your Crystal report ....the only thing you have to do then is to laod the report ...
read this ....it is much easier ...
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx
http://www.emoreau.com/Entries/Articles/2006/09/Feeding-Crystal-Reports-from-your-application.aspx
What version of Crystal?
Please check the full version in HELP --> ABOUT CRYSTAL
Most versions don't work with Office 2007. Full support is added with CR2010. There may also be a service pack that adds support to earlier versions like CR2008 and CR XI R2.
mlmcc
Please check the full version in HELP --> ABOUT CRYSTAL
Most versions don't work with Office 2007. Full support is added with CR2010. There may also be a service pack that adds support to earlier versions like CR2008 and CR XI R2.
mlmcc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.