dXXXfenton@bway.net.invalid (David W. Fenton) wrote in
news:9407AA3A3dfentonbwaynetinvali@24.168.128.78:
[color=blue]
>
MissingAddress@Invalid.Com (Lyle Fairfield) wrote in
><Xns9406D03732852FFDBA@130.133.1.4>:
>[color=green]
>>steve@nospam.com (Steve) wrote in
>>news:3f7a0cfb.84228243@news.westnet.com:
>>[color=darkred]
>>> On 29 Sep 2003 23:26:14 GMT, Lyle Fairfield
>>><MissingAddress@Invalid.Com> wrote:
>>>
>>><snip>
>>>
>>>>
>>>> Of course one might think that the things that XP does that 97
>>>>can't do are infinitely faster (or infinitely slower, depending
>>>>upon one's point of view).
>>>>
>>>
>>> For a database desktop developer, what are some of the things in
>>> XP that you use which are not provided in 97?[/color]
>>
>>PivotChart and PivotTable Views[/color]
>
> How many applications have you ever developed that would have
> benefitted from these? How many required it?[/color]
None; none.[color=blue]
>[color=green]
>>XML Support[/color]
>
> Have you ever used this, other than to get around the ADP's lack of
> local tables?[/color]
Nver for any reason.
[color=blue][color=green]
>>Extended Property Support with Microsoft SQL Server 2000[/color]
>
> Not much use if you're not using SQL Server 2K.
>[color=green]
>>Round-tripping[/color]
>
> ???[/color]
You can now work with and modify Access 2000 files in Access 2002 without
converting the file format. This allows you to easily share different
versions of database files with other Access users.
[color=blue][color=green]
>>Multiple Undo and Redo[/color]
>
> How is this different from other versions of Access? Yes, the Undo
> levels are limited, and some things are not undoable, but they
> aren't only one level deep. Or do you mean in data editing?[/color]
You now have the ability to undo and redo multiple actions in Design view
in all objects in your Microsoft Access databases and in views, stored
procedures, and functions in your Microsoft Access project.
[color=blue][color=green]
>>Batch Updates in Access Projects using Microsoft SQL Server[/color]
>
> Wasn't this possible with ADO in A2K?[/color]
I don't know.
[color=blue][color=green]
>>Updateable Off-line Data Access Pages[/color]
>
> How many DAPs have you developed?[/color]
None.
Do they still have the problems[color=blue]
> MichKa adduced after the initial release in A2K?[/color]
No idea.
[color=blue][color=green]
>>Conversion Error Logging[/color]
> Conversion from *what*? Earlier versions of Access? Other data
> formats?[/color]
If problems are encountered when converting from Access 95 and later
versions, Access 2002 will now create a table that lists information about
each error, making it much easier to identify and solve problems.
[color=blue][color=green]
>>Subforms/Subreports that Live in Design view[/color][/color]
You can now open subforms or subreports in their own Design view window
directly from within the form or report or from the View menu. Scrolling
has also been improved so that it is easier to work with subforms and
subreports in Design view.
[color=blue]
> I would like to go back to the A97 method where the
> subforms/subreports are not embedded in the form/report, because
> there just isn't enough space. At least, I'd like the option to
> turn off the new behavior and return to the A97 behavior (which for
> me is far, far easier in every way).
>[color=green]
>>Password Security in an Access Project[/color]
> What kind of password security? And if you're not using ADPs, is
> this relevant?[/color]
Access Project Features are relevant to Access Projects.[color=blue]
>[color=green]
>>The Linked Table Wizard[/color]
>
> What about it? Improved? What improvements?[/color]
The Linked Table Wizard guides you through the process of linking your
tables to a SQL Server database, and does this all from within your Access
project.
[color=blue][color=green]
>>Improved Support for International Complex-scripts[/color][/color]
[color=blue]
> Improved over A2K? How?[/color]
Access 2002 now exposes complex-script interface items easily, which means
that with a simple click, you can switch the reading direction from left-
to-right to right-to-left in language-specific objects.
[color=blue][color=green]
>>Improved Accessibility Features[/color]
>
> Do you have clients that use these?[/color]
No.
What are those improved features?
[color=blue][color=green]
>>Access 2002 now provides even greater ease in working with forms
>>and reports.
>> Pressing F8 in form or report Design will now display the
>> field list. Pressing ENTER after selecting a field in the
>> field list in form or
>> report Design view will automatically add the field to
>> the form
>>or
>> report design surface. Pressing CTRL+TAB will
>> move the focus
>>from
>> a form or report section to a subsection. Two
>> additional powers (1000% and 500%) have been added to the Zoom
>> option in print preview.[/color]
>
> While things like these shortcuts in form/report design/view are
> nice little additions, none of them really provides functionality
> that was not there already, except for the increased magnification
> (something I'm not sure is of much benefit). A real benefit would
> be a ZOOM in DESIGN view, so that you could deal with closely
> spaced and highly formatted reports at the design stage.
>
> Really, Lyle, you're being a shill for Microsoft here, just
> repeating the features list that MS has put out. Most of these
> things are not "features" that you need personally or use on a
> daily basis (if ever).[/color]
Actually I was trying to explain why XP is minimally slower. It does more
things; it's bigger.
Whether any of these as wonderful is another question.
--
Lyle
(for e-mail refer to
http://ffdba.com/contacts.htm)
