Customer Reviews

Microsoft Access 2002 Upgrade [OLD VERSION]

5 star:		(1)
4 star:		(0)
3 star:		(1)
2 star:		(0)
1 star:		(2)

 

 

Well I upgrade my Access 2000 to Access 2002. After entering in your product key it tells you it will only work for 50 days unless being activated by Microsoft. Ok, no big deal I did this via the internet. I had to reimage my PC recently due to it locking up and then it tells me it has already been registered on another PC and I need to call a number. Now this is irritating because I also like to use Access on a test machine of mine which tends to get reimaged a lot. Another problem is that I have to completely install Access 2000 before I install Access 2002. I know it's an upgrade, but if I ever need to reinstall why can't I simply use my old product key to enter to verify I had purchased the older version and not have to reinstall Access 2000?

Now first of all there are not a lot of new features in Access 2002 and I've noticed the file sizes grow larger faster and I need to constantly recompact my database.

Oh the product has a new look and it's a little prettier but it has no new "got to have it" features. Luckily one new feature is to save to the older versions of MS Access.

I like to purchase my software but I feel like I'm being treated like a criminal by Microsoft and given a hassle.

I've gone back to Access 2000 and next time I need a new database, it won't be Microsoft.

Access 2002 is a big pain if you're upgrading and need to use on multiple machines.(Even if you only use one copy at a time like I do.)

Microsoft Access is one of the other core Office applications I use the most, but I'm a little frustrated when it comes to compatibility, Microsoft still has not gotten it right! They need to focus on consistency and not new features only (And there aren't many new features Access 2002 when it comes to the average user). One of my computers at home still uses Office 97 and I kept a copy of my music collection database in Access 97, in Access 2000 you were able to convert a 2000 database to 97 or vice-versa smoothly. In Access 2002 that feature has been giving me problems, when I convert a 2002 database to 97 it gets ruined. When I opened the converted database in 97 there is only one record (there should be 45 records in the table) in the database leaving me angry having to type back in every artiste data in Access 97 again! Don't think if you have the database in Access 2000 its smooth running all the way, it also gives minor and major problems converting with Access 2002. Now, if I had one little problem converting a database, think about the big business people who are keeping massive records of customers. Don't get me wrong, it's an easy to use application but I think it still has some jinx in it. Now Microsoft if only you would allow multiple installs in Office XP I would be able to upgrade that computer running Office 97. Please get it right!!!

Microsoft is too bossy about their upgrade policies. I own Access 95, but the package says that I am not eligible for this upgrade. You have to have Access 97 or later in order to use this product.

The hidden gem in Microsoft Access is the support for SQL (Structured Query Language). With it you can query, update, and manage relational databases. SQL takes a few hours to learn but perhaps a lifetime to master all the potentials. Microsoft Access 2002 support the latest standard: ANSI SQL-92 which ensures compatibility with other relational databases such as DB2 and Oracle. Thus it's a useful accessory for anyone working with relational databases.