Upgrading advise

Hi

I have an access 97 app which I have the option to upgrade to either access
2000 or access 2003. Which one should I choose. I have heard nasty things
about access 2000.

Thanks

Regards

re: Upgrading advise

John wrote:[color=blue]
> Hi
>
> I have an access 97 app which I have the option to upgrade to either
> access 2000 or access 2003. Which one should I choose. I have heard
> nasty things about access 2000.[/color]

Partly depends on why you want to upgrade.

A2000 has been pretty good IMO and a lot of people are still using it...
although many are migrating to 2003. We still develop everything in A2000
because anyone with 2000/2002/2003 can use it and we don't have to maintain
different versions.

I've only found 2003 better when using an SQLServer backend but that's only
because SQLServer2000 came out after A2000.
--
regards,

Br@dley

re: Upgrading advise

If we move to access 2000, is it then easier to move to access 2003 when we
need to?

Thanks

Regards

"Br@dley" <dontlookforme@google.com> wrote in message
news:dutldo$l74$1@news-02.connect.com.au...[color=blue]
> John wrote:[color=green]
>> Hi
>>
>> I have an access 97 app which I have the option to upgrade to either
>> access 2000 or access 2003. Which one should I choose. I have heard
>> nasty things about access 2000.[/color]
>
> Partly depends on why you want to upgrade.
>
> A2000 has been pretty good IMO and a lot of people are still using it...
> although many are migrating to 2003. We still develop everything in A2000
> because anyone with 2000/2002/2003 can use it and we don't have to
> maintain different versions.
>
> I've only found 2003 better when using an SQLServer backend but that's
> only because SQLServer2000 came out after A2000.
> --
> regards,
>
> Br@dley
>[/color]

re: Upgrading advise

John wrote:[color=blue]
> If we move to access 2000, is it then easier to move to access 2003
> when we need to?
>
> Thanks
>
> Regards[/color]

It is easy in that A2003 still supports the A2000 file format so in theory
the database will work with no modifications. I've only encountered a few
things that don't work but only to do with conditional formatting and ADPs.
Many of our clients that use our A2000 databases have since updated to
A2003.

If you are upgrading I'd go to A2003, not A2000 then A2003. Seems a waste of
money?

There's also a new version due out this year just to throw another spanner
in the works:)
[color=blue]
> "Br@dley" <dontlookforme@google.com> wrote in message
> news:dutldo$l74$1@news-02.connect.com.au...[color=green]
>> John wrote:[color=darkred]
>>> Hi
>>>
>>> I have an access 97 app which I have the option to upgrade to either
>>> access 2000 or access 2003. Which one should I choose. I have heard
>>> nasty things about access 2000.[/color]
>>
>> Partly depends on why you want to upgrade.
>>
>> A2000 has been pretty good IMO and a lot of people are still using
>> it... although many are migrating to 2003. We still develop
>> everything in A2000 because anyone with 2000/2002/2003 can use it
>> and we don't have to maintain different versions.
>>
>> I've only found 2003 better when using an SQLServer backend but
>> that's only because SQLServer2000 came out after A2000.
>> --
>> regards,
>>
>> Br@dley[/color][/color]

--
regards,

Br@dley

re: Upgrading advise

"Br@dley" <dontlookforme@google.com> wrote in
news:duvk5o$he2$1@news-02.connect.com.au:
[color=blue]
> If you are upgrading I'd go to A2003, not A2000 then A2003. Seems
> a waste of money?[/color]

Well, there are two questions on the table:

1. what version of Access to upgrade workstations to,

2. what version of Access to upgrade the application to.

The answer to #1 is 2003.

The answer for #2 is 2000.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

re: Upgrading advise

David W. Fenton wrote:[color=blue]
> "Br@dley" <dontlookforme@google.com> wrote in
> news:duvk5o$he2$1@news-02.connect.com.au:
>[color=green]
>> If you are upgrading I'd go to A2003, not A2000 then A2003. Seems
>> a waste of money?[/color]
>
> Well, there are two questions on the table:
>
> 1. what version of Access to upgrade workstations to,
>
> 2. what version of Access to upgrade the application to.
>
> The answer to #1 is 2003.
>
> The answer for #2 is 2000.[/color]

Yep, that's what most people do.
--
regards,

Br@dley