Active TopicsMemberlistSearchHelpRegisterLogin

Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Schedule anomaly Post Reply Post New Topic
Author Message
Jerome
Newbie
Newbie
Avatar

Joined: 24 Oct 2007
Location: Netherlands
Online Status: Offline
Posts: 2
Quote Jerome Replybullet Topic: Schedule anomaly
    Posted: 24 Oct 2007 at 7:12am

Hi everyone,

I'm all new here but I'm confronted with a problem at work that I just can't solve so I figured I'd try my luck on the allmighty internet.
I have an MS Access database with some tables in it that I use for some of my reports. When I use the report designer, everything works just fine. When I save and want to schedule the report, I get a "Failed: PEStartPrintJob : Unable to open database".
 
How can the designer have full access but when scheduled it does not work? There is no password on the database.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 24 Oct 2007 at 12:33pm
What are you using to schedule the report?  Is it on a different computer than the one that the designer is on?  Is your Access database on your computer or on the network?  How are you  connecting to the database? (i.e., what type of connection are you using?)
 
I suspect that you're scheduling from a different machine and that the user ID that the scheduling service run under doesn't have access to the folder where the database file is located.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Jerome
Newbie
Newbie
Avatar

Joined: 24 Oct 2007
Location: Netherlands
Online Status: Offline
Posts: 2
Quote Jerome Replybullet Posted: 26 Oct 2007 at 12:47am
Hi Hilfy/Dell,
Yes, that would be my guess too. The Access database is on a different network than Crystal. And let me say that I'm using a very old version of Crystal, version 7 from the year 2000. I'm connecting to the database in just the regular way and so the scheduling.
 
The strange thing is that it ran the first 3 scheduled reports just fine. But when I tried it again a few days later, I got the 'cannot open database' error.
But how do I find out under what name the scheduler tries to open the database? Once I know that, I can simply give access to that ID.
 
Thanks,
Jerome
 
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 26 Oct 2007 at 6:30am
What software are you using to schedule the report?
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.