Is Access 2000 still OK to develop in?

S

Snowsride

Hi

I retired at the end of 2006 and am now thinking of doing some database
consultancy work using MS Access. Can I successfully use Access 2000 or do I
really (and I mean really) need to upgrade to Access 2007? If so what are
the new features that forum members believe I can't do without?!

Thanks
 
K

Ken Snell \(MVP\)

ACCESS 2000 (be sure that you've updated it to SP3) is still used by many
people. Databases that you develop using it usually can be used by people
with later versions, and usually with few problems. However, there are many
new features that were introduced in the later versions that are "nice" to
have (but are not "necessary" to have in most cases) -- e.g., ability to
pass OpenArgs to a report, availability of the Printer object in VBA code,
etc.

I prefer ACCESS 2003 (SP2 is what I'm using -- the latest update, SP3, has
introduced many bugs for which Microsoft has not released patches/fixes yet)
because it's very stable and includes some nice features.

ACCESS 2007 is a very different version from all that came before it, and is
still somewhat buggy in many respects. Some people really like it; others do
not.

You may want to see what versions your potential user base has, and aim at
that version.
 
D

Daniel Pineault

If you are consulting the driving factor will be whatever version of
office/access your customers are using.

I do dev in 2000, 2003 and now 2007 for various customers.
 
D

David W. Fenton

ACCESS 2000 (be sure that you've updated it to SP3)
Click to expand...

If you arent' using Outlook 2000, that's safe, but if not, you
should consider whether or not you want to be exposed to the
Draconian attachment blocking fix that was imposed in SP3 of Office
2K.

All you really need for a safe A2K is Access/Office SR1 and Jet 4
SP6 or higher. I have one particular client that's still on Office
2K and they are all using SR1 and have no Access stability problems
whatsoever.
 
T

Tony Toews [MVP]

Snowsride said:
I retired at the end of 2006 and am now thinking of doing some database
consultancy work using MS Access. Can I successfully use Access 2000 or do I
really (and I mean really) need to upgrade to Access 2007? If so what are
the new features that forum members believe I can't do without?!
Click to expand...

I develop in A2003 and create the MDE in A2000 so any version of
Access 2000 or newer can run the MDE. But this is more for apps I
create and for which folks will use runtimes I supply.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Top