• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 982
  • Last Modified:

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

 
0
fhenreaux
Asked:
fhenreaux
1 Solution
 
ErwindeVriesCommented:
Please a screenshot with the error in question.
0
 
John (Yiannis) ToutountzoglouInstructor Multiengine PilotCommented:
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 ...
0
 
John (Yiannis) ToutountzoglouInstructor Multiengine PilotCommented:
0
 
mlmccCommented:
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
0
 
fhenreauxAuthor Commented:
Finally, I keep on using a mdb. I had a problem with the oledb jet 4.0, and I changed it to oledb 12.0 and my application is working now.
I think I'll be back later with my issue, now I don't have a lot of time to spend on it.

Thank you all.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now