upgrade to Access 2002 or 2003? | | |
I've built all of my apps in Access 97, but I think it's time I moved
to some newer technology (a little late to the web app game...) so I'm
considering an upgrade. Any reason not to go straight to 2003 and
skip 2000/2002? Will Access 2003 create issues for clients that are
still running Win98/2000? What else do I need to consider?
Any guidance would be helpful
thanks-
jeff | | | | re: upgrade to Access 2002 or 2003?
There's been some talk recently that you can not open a 2003 db (containing
VBA) seamlessly, unless you provide a digital certificate!
I for one will not be going within 50 miles of 2003, until I know more about
*that* one.
HTH,
TC
"Jeff Keller" <jkeller701@aol.com> wrote in message
news:c5ddd5b8.0311061959.4ad4b83c@posting.google.c om...[color=blue]
> I've built all of my apps in Access 97, but I think it's time I moved
> to some newer technology (a little late to the web app game...) so I'm
> considering an upgrade. Any reason not to go straight to 2003 and
> skip 2000/2002? Will Access 2003 create issues for clients that are
> still running Win98/2000? What else do I need to consider?
>
> Any guidance would be helpful
>
> thanks-
> jeff[/color] | | | | re: upgrade to Access 2002 or 2003?
"TC" wrote
[color=blue]
> There's been some talk recently that
> you can not open a 2003 db (containing
> VBA) seamlessly, unless you provide a
> digital certificate![/color]
You can set macro security (new) to "Low" and you won't be any less secure
than you have been since Access 1.0. Or you can use a "selfcert" to certify
your own databases, if you aren't in the business and need to certify with a
public certificate.
And, if it isn't "signed" and you haven't set macro security to "Low", all
it does is give you a message box telling you that if it has VBA it could do
damage.
[color=blue]
> I for one will not be going within
> 50 miles of 2003, until I know more
> about *that* one.[/color]
But, if you don't need improved collaboration features in a corporate
setting and/or improved XML, then there's little compelling reason to change
from Access 2002. There are some modest improvements for the individual user
and small organization, but nothing earthshaking.
Larry Linson
Microsoft Access MVP | | | | re: upgrade to Access 2002 or 2003?
"Jeff Keller" <jkeller701@aol.com> wrote in message
news:c5ddd5b8.0311061959.4ad4b83c@posting.google.c om...[color=blue]
> I've built all of my apps in Access 97, but I think it's time I moved
> to some newer technology (a little late to the web app game...) so I'm
> considering an upgrade. Any reason not to go straight to 2003 and
> skip 2000/2002? Will Access 2003 create issues for clients that are
> still running Win98/2000? What else do I need to consider?
>
> Any guidance would be helpful
>
> thanks-
> jeff[/color]
According to Larry Linson, you should stick with Access 97. None of the
Access 2K series works properly.
Paul | | | | re: upgrade to Access 2002 or 2003?
RE/[color=blue]
> What else do I need to consider?[/color]
I develop in both 97 and 2k.
If I had my druthers, I'd to it all in 97 because 97 is quicker/easier to work
with from moment-to-moment. A2k seems to want to save everything whenever I
change the least little thing.
--
PeteCresswell | | | | re: upgrade to Access 2002 or 2003?
I reported quite a while ago that XML and moving to .Net was central to
Access 2003.
As far as XP (2002) goes, you can develop for 97, 2000 and 2002. I like
AccessXP quite a bit as it fixed a lot of problems with 2002.
Now, here is your choice. You can go with 2003 and keep it for quite a
while, probably the same with 2002. If you stick with 97, you can probably
use it for quite a while also. For me, I always go with the latest version
when I purchase. The simple reason is I can always use older versions that I
have but I may run across the client that wants the newer version. If that
happens then I have an advantage that my competition does not.
--
******************************
Fred Parker
Lynn Consulting Group, L.L.C. http://www.lynnconsultinggroup.com
****************************** | | | | re: upgrade to Access 2002 or 2003?
Larry, as for the certificates issue, say a user has set the new security
levels (whatever they are) to high. What (in summary) does the developer
need to do to ensure that his db product can be opened without any warnings?
Is that the "self cert" thing? What (roughly) is involved in terms of the
process, cost & complexity?
TIA,
TC
Larry Linson <bouncer@localhost.not> wrote in message
news:dcGqb.9122$E9.1948@nwrddc01.gnilink.net...[color=blue]
> "TC" wrote
>[color=green]
> > There's been some talk recently that
> > you can not open a 2003 db (containing
> > VBA) seamlessly, unless you provide a
> > digital certificate![/color]
>
> You can set macro security (new) to "Low" and you won't be any less secure
> than you have been since Access 1.0. Or you can use a "selfcert" to[/color]
certify[color=blue]
> your own databases, if you aren't in the business and need to certify with[/color]
a[color=blue]
> public certificate.
>
> And, if it isn't "signed" and you haven't set macro security to "Low", all
> it does is give you a message box telling you that if it has VBA it could[/color]
do[color=blue]
> damage.
>[color=green]
> > I for one will not be going within
> > 50 miles of 2003, until I know more
> > about *that* one.[/color]
>
> But, if you don't need improved collaboration features in a corporate
> setting and/or improved XML, then there's little compelling reason to[/color]
change[color=blue]
> from Access 2002. There are some modest improvements for the individual[/color]
user[color=blue]
> and small organization, but nothing earthshaking.
>
> Larry Linson
> Microsoft Access MVP
>
>[/color] | | | | re: upgrade to Access 2002 or 2003? etickettwothousand@hotmail.com (fp) wrote in
<fPWqb.19399$p9.1129@nwrddc02.gnilink.net>:
[color=blue]
>As far as XP (2002) goes, you can develop for 97, 2000 and 2002. I
>like AccessXP quite a bit as it fixed a lot of problems with 2002.[/color]
Eh?
The version of Access in Office XP was Access 2002. There is no
such standalone product as Access XP.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc | | | | re: upgrade to Access 2002 or 2003?
I don't think self-cert is sufficient if you are distributing the product. I
think you have to purchase/license from a vendor of that service.
That assuredly means that people are just going to have to live with a
message on the free stuff that I distribute. Unless, of course, some vendor
thought that it'd be such good advertising for me to use their product that
they'd provide it for me free. I'm afraid my lack of "star power" eliminates
that as a possibility.
I don't know what the certification service costs, because I don't do
general distribution. All my "paying work" is either consulting or "bespoke"
systems done for specific clients.
But, if I were to expand to address a more general, multi-customer market,
then it appears that I'd be forced to investigate. It would just be a
necessary cost of doing business and like all such costs, would affect my
cost/price/ROI calculations.
Larry Linson
"TC" <a@b.c.d> wrote in message news:1068253295.193449@teuthos...[color=blue]
> Larry, as for the certificates issue, say a user has set the new security
> levels (whatever they are) to high. What (in summary) does the developer
> need to do to ensure that his db product can be opened without any[/color]
warnings?[color=blue]
> Is that the "self cert" thing? What (roughly) is involved in terms of the
> process, cost & complexity?
>
> TIA,
> TC
>
>
> Larry Linson <bouncer@localhost.not> wrote in message
> news:dcGqb.9122$E9.1948@nwrddc01.gnilink.net...[color=green]
> > "TC" wrote
> >[color=darkred]
> > > There's been some talk recently that
> > > you can not open a 2003 db (containing
> > > VBA) seamlessly, unless you provide a
> > > digital certificate![/color]
> >
> > You can set macro security (new) to "Low" and you won't be any less[/color][/color]
secure[color=blue][color=green]
> > than you have been since Access 1.0. Or you can use a "selfcert" to[/color]
> certify[color=green]
> > your own databases, if you aren't in the business and need to certify[/color][/color]
with[color=blue]
> a[color=green]
> > public certificate.
> >
> > And, if it isn't "signed" and you haven't set macro security to "Low",[/color][/color]
all[color=blue][color=green]
> > it does is give you a message box telling you that if it has VBA it[/color][/color]
could[color=blue]
> do[color=green]
> > damage.
> >[color=darkred]
> > > I for one will not be going within
> > > 50 miles of 2003, until I know more
> > > about *that* one.[/color]
> >
> > But, if you don't need improved collaboration features in a corporate
> > setting and/or improved XML, then there's little compelling reason to[/color]
> change[color=green]
> > from Access 2002. There are some modest improvements for the individual[/color]
> user[color=green]
> > and small organization, but nothing earthshaking.
> >
> > Larry Linson
> > Microsoft Access MVP
> >
> >[/color]
>
>[/color] | | | | re: upgrade to Access 2002 or 2003?
"Paul Ryan" wrote
[color=blue]
> According to Larry Linson, you should
> stick with Access 97. None of the
> Access 2K series works properly.[/color]
Paul Ryan = Don P Mellon.
Larry Linson has said no such thing -- in fact, I've said that Access 2002
is a marked improvement over Access 2000, which finally is a lot more stable
after 3 Service Packs (more than any other version of Access, ever), and
Access 2003 does not seem to have suffered the usual
one-good-release-one-bad-release curse.
Larry Linson | | | | re: upgrade to Access 2002 or 2003?
"Paul Ryan" <nospam@any.net> wrote in message
news:e2a4c4b2cfba0d5e1e3d246b3eaee80a@news.teranew s.com...[color=blue]
>
> "Jeff Keller" <jkeller701@aol.com> wrote in message
> news:c5ddd5b8.0311061959.4ad4b83c@posting.google.c om...[color=green]
> > I've built all of my apps in Access 97, but I think it's time I moved
> > to some newer technology (a little late to the web app game...) so I'm
> > considering an upgrade. Any reason not to go straight to 2003 and
> > skip 2000/2002? Will Access 2003 create issues for clients that are
> > still running Win98/2000? What else do I need to consider?
> >
> > Any guidance would be helpful
> >
> > thanks-
> > jeff[/color]
>
> According to Larry Linson, you should stick with Access 97. None of the
> Access 2K series works properly.
>
> Paul
>[/color]
Good one. AFAIK, Larry hasn't built anything in years.
--NML | | | | re: upgrade to Access 2002 or 2003?
Sorry, I meant to say AXP fixed some problems in A2K.
-- | | | | re: upgrade to Access 2002 or 2003?
"Nicolas M. Leary" wrote
[color=blue]
> Good one.[/color]
Patting yourself on the back again, I see, Don. | | | | re: upgrade to Access 2002 or 2003?
Hasn't this guy gone away yet?
--
******************************
Fred Parker
Lynn Consulting Group, L.L.C. http://www.lynnconsultinggroup.com
****************************** | | | | re: upgrade to Access 2002 or 2003?
"Larry Linson" <bouncer@localhost.not> wrote in message
news:ZBirb.15303$E9.6014@nwrddc01.gnilink.net...[color=blue]
> "Nicolas M. Leary" wrote
>[color=green]
> > Good one.[/color]
>
> Patting yourself on the back again, I see, Don.
>
>[/color]
??? | | | | re: upgrade to Access 2002 or 2003?
"Don P Mellon" <8bedht@earthlink.com> wrote
[color=blue]
> ???[/color]
!!! |  | Similar Microsoft Access / VBA bytes | | | /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 226,501 network members.
|