[AccessD] AXP Question

Detailed question #1 

I thought you couldn't build / amend reports on the fly in a live,
multi-user database in AXP? Whenever I have tried to do anything of the sort
I got a flat refusal from Access. I was never intending to allow them to go
into Design view as then they might fiddle with the data source (erk!) - was
going to build a custom properties dialogue. But when you change a report's
properties through code Access still forces an exclusive lock. If I use
querydefs as the sources I can amend the queries - but that's the one thing
I won't let them do.

??

-----Original Message-----
From: Wortz, Charles [mailto:CWortz at tea.state.tx.us] 
Sent: 09 June 2003 14:56
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] AXP Question


Roz,

I think you misunderstand John's comment.  If there is something that is
constantly changing, then you need to develop a way for the user to be able
to pick from a selection of options to get what they want.  As you mentioned
in another of your posts on this thread, sometimes they want to change the
sort order, sometimes they want to change the font.  Have you thought of
designing a form where they get to select such options and then base the
report on those selections?  It may not be easy to give them all the options
they want/need, but if this is the only way to keep paying customers, then
you will find a way to do it.

Good luck, and don't feel afraid to ask us more detailed questions as you
get into this.

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: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk] 
Sent: Monday 2003 Jun 09 08:30
To: 'accessd at databaseadvisors.com'
Subject: RE: [AccessD] AXP Question

That's what I'm moaning about - I can't change the reports programmatically
any more. ><

Roz

-----Original Message-----
From: John Colby [mailto:jcolby at colbyconsulting.com] 
Sent: 09 June 2003 14:10
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] AXP Question


It sounds to me like the report changes due to customer needs.  However it
seems that the way to handle this would be to analyze what is constantly
changing and do that programatically.

John W. Colby
www.colbyconsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Wortz, Charles
Sent: Monday, June 09, 2003 9:06 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] AXP Question


Roz,

Users that want constant changes to the layout of reports should expect
delays, if not worse! <grin>  If they cannot agree on the layout of a report
and then live with it until a major change is needed, they should find other
employment. <grin>

Once I put a report into production, the user has to live with it until the
next set of scheduled changes or a business/regulatory rule change. In
development, the user can suggest all sort of changes, but once they
sign-off on it and it goes into production they must live with their
decisions.  And higher management is willing to enforce those rules with few
exceptions because they recognize IT as a limited and valuable resource.

If your environment is different from this, then you may want to consider
other job opportunities.

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 _______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com