Marcus, Scott (GEAE, RHI Consulting)
scott.marcus at ae.ge.com
Fri Mar 7 09:11:01 CST 2003
Richard, It has been a long time since I've used Crystal with a password protected mdb and cannot remember any of the details (it isn't complicated). The Crystal reports documentation gives the instructions for doing this. I've have done this in the past by referring to that documentation. Are you lacking this documentation? I can look it up this weekend if you are. What version of the software are you using? Maybe the documentation has changed much like that of the newer versions of the Access help file. Often times someone's original post gets lost in tangents. As long as these tangents are on topic(Access related), I see nothing wrong in commenting on them, or continuing the tangent. When appropriate we try to change the subject line. The tangents, while not helping you, are helping others. To be honest with you, I didn't even see your original post and typically only read the previous 1 or 2 posts that are embedded in the replies. I actually thought the posts were about the advantages and disadvantages of using Crystal with Access. ----- Scott Marcus A major disadvantage to doing anything is not knowing how to. Figuring it out is also half the fun. -----Original Message----- From: Griffiths, Richard [mailto:R.Griffiths at bury.gov.uk] Sent: Friday, March 07, 2003 9:05 AM To: 'accessd at databaseadvisors.com' Subject: RE: [AccessD] Access and Crystal Reports and one of the major disadvantages is that nobody knows how to ....... Hi using code and CR ocx... how do you run a Crystal Report when the Access Db has 1) a password and/or 2) uses a system mdw Many thanks Richard this was the original thread!!! > -----Original Message----- > From: Marcus, Scott (GEAE, RHI Consulting) [SMTP:scott.marcus at ae.ge.com] > Sent: 07 March 2003 13:23 > To: 'accessd at databaseadvisors.com' > Subject: RE: [AccessD] Access and Crystal Reports > > One of the major advantages of using Crystal Reports is the ability to > make a > dictionary (list of fields and functions) of complex data structures for > end > users to make their own reports. I have found that this ability "beats" > Access > reports hands down. I still use Access for my canned reports but encourge > end > users to use Crystal if they want on the fly reporting abilities. Plus it > keeps > end users out of the mdb's. > > Scott Marcus > > -----Original Message----- > From: Shamil Salakhetdinov [mailto:shamil at smsconsulting.spb.ru] > Sent: Thursday, March 06, 2003 4:59 PM > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Access and Crystal Reports > > > > Access 2002 and CR 9.0 are > > almost identical in their feature sets. > Charles, > > I thought the same but then I made approx. 50 real-life CR reports for > HRM/Payroll system and my customer was a real guru in both HRM/Payroll > programming/reporting and CR itself (I worked as his subcontractor) - and > I > soon realized that despite the fact that the feature set of MS Access and > CR > seems to be very similar, the real power of CR is in its unique and > looking > at first not very significant feature of allowing to have and manipulate > on > runtime of several (as many as you wish) independent sections/areas of > Report Header/Footer, Page Header/Footer, Group Header/Footer and > Details... > > The only area where I've found MS Access "beats" CR 8.x, which I used, is > when you need in CR to copy and paste (or cut and paste) a group of > controls > within one report or between reports - here CR sometimes goes "crazy" and > you need to realigh controls manualy after paste operation... > > Charles, I'd not like to have this thread to become"religious" debate "CR > vs. MS Access report generator" - let's stop it? - after your > contr-arguments if you wish! :) > > Shamil > > ----- Original Message ----- > From: "Wortz, Charles" <CWortz at tea.state.tx.us> > To: <accessd at databaseadvisors.com> > Sent: Thursday, March 06, 2003 10:37 PM > Subject: RE: [AccessD] Access and Crystal Reports > > > > Shamil, > > > > I just got through with a three day course on what's new in Crystal > > Reports 9.0 and I stand by my statement that Access 2002 and CR 9.0 are > > almost identical in their feature sets. I did not say they were equally > > easy to learn or use, because that is subject to your background > > experience and personal preferences. > > > > I also stand by my assertion that there is no reason to buy CR to > > produce reports from an Access database. > > > > If you have C++, C#, VB or some other platform as your front-end to SQL > > Server or Sysbase or some other database other than Access, then CR > > makes sense. > > > > Charles Wortz > > Software Development Division > > Texas Education Agency > > 1701 N. Congress Ave > > Austin, TX 78701-1494 > > 512-463-9493 > > CWortz at tea.state.tx.us > > > > > > > > -----Original Message----- > > From: Shamil Salakhetdinov [mailto:shamil at smsconsulting.spb.ru] > > Sent: Thursday 2003 Mar 06 13:19 > > To: accessd at databaseadvisors.com > > Subject: Re: [AccessD] Access and Crystal Reports > > > > > Why pay extra for Crystal Reports? > > Sorry for my jumping in, Charles, > > > > I used to use Crystal Reports(CR) to build advanced reports with C++ > > last spring - and I'd say that CR can give 1000 points allowance to MS > > Access reports' designer and still win nevertheless this big handicap... > > On first glance CR looks for a MS Access developer like a very sprawl > > and not as intuitional as MS Access report designer tool but when one > > gets the rules of report generation used by CR they understand that CR > > allows to create reports, which can't be created in MS Access - and I > > think that all of MS Access types of reports can be created by using > > CR... > > > > And of course CR reports created to view in MS Access can be (re-)used > > in VB, C++, DELPHI, on the Web etc.etc.... > > > > Shamil > > > > ----- Original Message ----- > > From: "Wortz, Charles" <CWortz at tea.state.tx.us> > > To: <accessd at databaseadvisors.com>; <dba-VB at databaseadvisors.com> > > Sent: Thursday, March 06, 2003 9:48 PM > > Subject: RE: [AccessD] Access and Crystal Reports > > > > > > > Richard, > > > > > > May I inquire why you want to use Crystal Reports with Access? Access > > > > > 2002 and Crystal Reports 9.0 are almost identical in their feature > > > sets, so why not use Access for your reports? Why pay extra for > > > Crystal Reports? > > > > > > Charles Wortz > > > > > > -----Original Message----- > > > From: Griffiths, Richard [mailto:R.Griffiths at bury.gov.uk] > > > Sent: Thursday 2003 Mar 06 12:09 > > > To: 'dba-VB at databaseadvisors.com' > > > Cc: 'AccessD at databaseadvisors.com' > > > Subject: [AccessD] Access and Crystal Reports > > > > > > Hi > > > > > > using code how do you run a Crystal Report when the Access Db has 1) a > > > > > password and/or 2) uses a system mdw > > > > > > Many thanks > > > > > > Richard > > _______________________________________________ > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -------------------------------------------------------------------------------- ------------------------------------ This e-mail, together with any files transmitted with it, is confidential and intended solely for the use of the individual to whom it is addressed. If you are not the intended recipient, or the person responsible for delivering to the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited without liability on our part. If you have received this e-mail in error please notify the sender. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com