I can't believe this. Management has now come back and said that they want
proof from Microsoft that Access 2000 is a more stable environment than
Access 95. They don't want to spend the money to upgrade if they are
still
going to have corrupt databases, etc...
Databases get corrupted sometimes. In Access, this is a fact of life. But
Access 95 is trash. I have never in my life seen such a wretched hive of
"Access Violations" and "General Protection Faults".
One important reason to stay "sort of current" is support. Microsoft
supports the current version and two versions back. When a new version "n"
gets released, they no longer support anything before version "n - 2". The
current version of Access / Office is 2003. So Microsoft will support
Versions 2003, XP and 2000. Access 95 and Access 97 are no longer supported
by Microsoft, so if you have any kind of tech support issue, Microsoft will
charge you $95 for the support incident, and then say, "Sorry, we no longer
support that version of the product". I don't think it is a vlalid reason
to upgrade to a new version simply because a new version has been released,
but here, you are correct in your "well duh" reasoning. Your bosses need to
get hit with a cluebat.
Access 2000 increases lots of the maximum specifications of a database, and
includes better support for international and unicode text. XP is even
better. I have seen Access 2003, but have no real experience with it. If
you have large databases that are approaching their size limits, it is
recommended to bump up to at least Access 2000, preferably to MSDE or SQL
Server. Access 2000 is also WAY more stable and reliable than Access 95.
Sometimes I don't know why I stay here.......
The company I work for seems to always be looking for Access / VBA / VB /
SQL / .Net folks:
http://www.tns-global.com
I still think the "Well,
DUH!!!!" is the only answer they needed to hear.
I whole-heartedly agree, and I feel your pain.
If any of you have any other ideas where I can get information straight
from
the source, I would be more than appreciative.
If it helps your cause, here is a snip from the Access 2000 Help file on
maximum specs:
<snip>
Maximum Specifications:
Microsoft Access database (.mdb) file size 2 gigabytes. However, because
your database can include linked tables in other files, its total size is
limited only by available storage capacity.
Number of objects in a database 32,768
Modules (including forms and reports with the HasModule property set to
True) 1,000
Number of characters in an object name 64
Number of characters in a password 14
Number of characters in a user name or group name 20
Number of concurrent users 255
</snip>
