Solved

Crystal Report: connected to Access 2007 with vb 2008

Posted on 2010-09-06
5
922 Views
Last Modified: 2012-05-10
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
Comment
Question by:fhenreaux
5 Comments
 
LVL 4

Expert Comment

by:ErwindeVries
ID: 33611374
Please a screenshot with the error in question.
0
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33612358
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
 
LVL 18

Expert Comment

by:John (Yiannis) Toutountzoglou
ID: 33612364
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 33621369
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
 

Accepted Solution

by:
fhenreaux earned 0 total points
ID: 33682373
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

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
Introduction When many people think of the WebBrowser (http://msdn.microsoft.com/en-us/library/2te2y1x6%28v=VS.85%29.aspx) control, they immediately think of a control which allows the viewing and navigation of web pages. While this is true, it's a…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now