Link to home
Start Free TrialLog in
Avatar of fhenreaux
fhenreauxFlag for Belgium

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

 
Avatar of ErwindeVries
ErwindeVries
Flag of Netherlands image

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 ...
Avatar of Mike McCracken
Mike McCracken

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
ASKER CERTIFIED SOLUTION
Avatar of fhenreaux
fhenreaux
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial