Solved

Crystal Report: connected to Access 2007 with vb 2008

Posted on 2010-09-06
5
944 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
scanning dentists xray (the small ones) 3 54
fso.FolderExists("\\server\HiddenFolder$") 4 66
Close tabpage of custom control 9 34
Sending receiving text messages in vb.net 15 35
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

777 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