Re: Access 2000 - Realtime Development - Should i stick with Access97
From: Jado (ploxly_at_hotmail.com)
Date: 06/23/04
- Next message: anonymous_at_discussions.microsoft.com: "Re: Email multiple receipients"
- Previous message: Tony C: ".NoMatch Compile Error"
- In reply to: Allen Browne: "Re: Access 2000 - Realtime Development - Should i stick with Access97"
- Next in thread: Allen Browne: "Re: Access 2000 - Realtime Development - Should i stick with Access97"
- Reply: Allen Browne: "Re: Access 2000 - Realtime Development - Should i stick with Access97"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Jun 2004 11:37:42 +0100
Thanks Allen
I'll be sticking with Access 97
just one last thing though...
if I needed to start using SQL Server to store Tables of an Access 97 front
end, would this force the need to upgrade.
if not, are there many major benefits of using A2000 appose to A97 in
conjunction with SQL Server 2000
I'll let you go now :)
Your comments have proved invaluable in helping me make the right decision
Many Thanks
Jado
"Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
news:elcFEU$VEHA.1888@TK2MSFTNGP11.phx.gbl...
> Comments interspersed.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Jado" <ploxly@hotmail.com> wrote in message
> news:O$lp5i6VEHA.1164@tk2msftngp13.phx.gbl...
> >
> > > The problem you refer to is the monolithic save. [snip]
> >
> > do you mean 2 developers working in design view?? (I would be the only
one
> > needing to access objects in design view)?
>
> If any other user is *using* (not only if they are designing) any form or
> report in the database, you will have problems saving in A2000 and later.
>
> > out of interest, after reading about all those possible problems, would
> you
> > mind telling me, in your opinion, the main benefits an upgrade from
Access
> > 97 to 2000 would bring.
> >
> > I've read about the new features of A2000, but as I've never dabbled, I
> > wouldn't know which features have proved to be well worth while, and
which
> > were a waste of time!
>
> If you store your data in Access tables, the only new, useful feature that
> works without problems is that Forms have an undo event.
>
> AutoCorrect causes more problems than it solves.
> Conditional Formatting is a nice idea, but buggy.
> The new field types do not work correctly.
> The new relationship types are not supported in the interface.
> You have to reset problem properties every time you create a table, text
> field, for form.
> Many of the bugs have been present for 4 years, and are not being fixed.
>
> So why upgrade? If you are working with JET/Access tables, they only
reason
> is because you have support clients who are using later versions.
>
>
- Next message: anonymous_at_discussions.microsoft.com: "Re: Email multiple receipients"
- Previous message: Tony C: ".NoMatch Compile Error"
- In reply to: Allen Browne: "Re: Access 2000 - Realtime Development - Should i stick with Access97"
- Next in thread: Allen Browne: "Re: Access 2000 - Realtime Development - Should i stick with Access97"
- Reply: Allen Browne: "Re: Access 2000 - Realtime Development - Should i stick with Access97"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|