Home > Software > Programming Language >

Reviews for MS Access 2000


Access 2000 good but has bugs -  MS Access 2000 Programming Language
MS Access 2000 

Newest Review: ... and left mouse click you can easily develop database programs for your personnel use or your office and if you know visual basic it will g... more

Access 2000 good but has bugs (MS Access 2000)

Lcars_UK

Member Name: Lcars_UK

Product:

MS Access 2000

Date: 19/06/01 (283 review reads)
Rating:

Advantages: Good Wizards, Easy to use, Easy to configure

Disadvantages: Date Bug

I have read some of the other opinions about Microsoft Access 2000.

And I agree that Microsoft has made real head way in the development of a home user/ Small Business user data solution.

Access 2000 has had a revamp, it looks and feels more like an Office App, and more importantly It has more support for programmer, you just need to use the jet 4.0 DBEngine and MDAC TYP 2.5.

But a bit like Access 97, 2000 has a date bug! If you are using Access to hold date, or you have experience of using date in Access, you will know that it really like holding Date in all format (Yeah right), Access like the American date format (mm/dd/yyyy), I my self as a Visual Basic programmer who uses Access as my Data storage media know the problem to do with storing Date in Access.

I don't confess to be a guru, but be warned there are some problem, but knowing Microsoft they will release a Service PAck that will correct the problem.


Summary:

Last members to rate this review:
(4 members total)

Technical+Tobes%2FEpiphany%2Fia_young%2FMR.COATES%2F

View all 4 member ratings

Overall rating: Useful

Nominate for a Crown:

See all newly Crowned Reviews

Last comment:
Technical+Tobes

- 21/06/01

I know exactly the bug you are referring too - however it was also present in Access 97. Regardless of what date format your system is set to, you have to convert to US format for SQL queries to work via VB.
Then again, when working in VB, it makes no difference what version of Access you use!
Cheers, TT.

Top