-
CR Wizard - MS Access XP
I have an Access database (XP) from which I created several Crystal Reports (8.5) because Access would not handle all the fields required for the reports. I apparently went about this backwards because now that I have started investigating how to be able to view the reports in Access I find that one actually must create the reports through Access. Hopefully, this will be a simple copy/paste procedure once I get into it.
The problem is that once I started up the Crystal Report Wizard and chose the query from which I wanted to create the first report, I was asked to enter a database password. My database does not have passwords. I have searched for a means to handle this but to no avail. Has anyone experienced this problem before?
Or better yet, what I really need to do is view the reports from within Access using the Crystal Active-X. I've been over the Accocx97.mdb example on how to set up a CR in Access, however in XP I don't see a place to put the file name of the report.
I'm hoping someone can help me real quick as I've already wasted too much time re-doing these reports in Crystal after having found out that Access won't handle them.
THANK YOU!!