Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Crystal Report: connected to Access 2007 with vb 2008

Posted on 2010-09-06
5
Medium Priority
?
977 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 101

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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

610 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