[AccessD] Access and Crystal Reports

Richard,

You forgot to mention in your original post that the FE was VB.  You
only mentioned you were using Access.  That's why we got off on a
tangent about the uses of Access reports and CR.

Now to your original question about how to access a secured Access BE:
IIRC, yesterday there was a thread about connections to a secured db.
The answer to that thread also should answer your question.

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: Griffiths, Richard [mailto:R.Griffiths at bury.gov.uk] 
Sent: Friday 2003 Mar 07 03:04
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] Access and Crystal Reports


A97 and CR8.0 - this post was cross-posted with VB list as the app
concerned is VB FE and Access BE - 
I know MS Access reporting is excellent, however, has anyone one got any
contributions that may provide and answer to the question TIA Richard

> -----Original Message-----
> From:	Wortz, Charles [SMTP:CWortz at tea.state.tx.us]
> Sent:	06 March 2003 18:49
> To:	accessd at databaseadvisors.com; dba-VB at databaseadvisors.com
> 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