Microsoft Access: The Database Software That Won't Die

Re:Microsoft Access: The Database Software That Won't Die by Clubber on Wednesday October 30, 2019 @05:00PM (#21402659)

My first real paying gig was Access 97 (I'm old). They actually taught it at my university at the time in the MIS/CIS path. I built a credentialing system for a small HMO. I was able to get it to support over 100 people, including report load. I split out the database from the front end (forms/reports) and put the database files on an NT4 share. When we grew and it started to buckle under load, I created an additional read-only share and replicated the read-write database to the read-only database every so often. This allowed me to split the users' load between those that needed read/write and those that needed read only.

Talk about a rapid design tool of both forms and reports (and schema), Access was tough to beat. I think Corel/WordPerfect had a similar concept as well.

Good times.

[ Parent | on HN ]

Re:Microsoft Access: The Database Software That Won't Die by HenryBemis on Wednesday October 30, 2019 @08:06PM (#21404411)

I made my first system for a client 20 years ago on MS Access, and the latest one was again (they asked, I didn't say no) I created a mini-MIS for another client. Reports, forms, tables, everything MS Access. I won't be insulted if MS renamed it to "SQL for dummies". Access just works!

[ Parent | on HN ]

Re:Microsoft Access: The Database Software That Won't Die by SigmundA on Wednesday October 30, 2019 @05:05PM (#21402716)

I got started using Access 2, so I'm older...

[ Parent | on HN ]

Re:Microsoft Access: The Database Software That Won't Die by ourmandave on Wednesday October 30, 2019 @05:12PM (#21402799)

Learned 3NF in an Access 2 class, so I might be older... =)

[ Parent | on HN ]

Re:Microsoft Access: The Database Software That Won't Die by linuxhiker on Wednesday October 30, 2019 @06:28PM (#21403576)

Dbase3 and Clipper here.

[ Parent | on HN ]

Re:Microsoft Access: The Database Software That Won't Die by pgrote on Wednesday October 30, 2019 @11:12PM (#21405406)

I hear you and raise you a Progress.

[ Parent | on HN ]

Re:Microsoft Access: The Database Software That Won't Die by tlavoie on Friday November 01, 2019 @06:07PM (#21424192)

Ugh, me too!

My manager was a huge fan of Progress, such that it became the de facto tool of choice whether it fit or not.

I was less of a fan, but just checking now, it still exists! I'm curious about this one blurb from their web site though, which proclaims, "Progress Named a ‘Strong Performer’ in The Forrester Wave™: Low-Code Development Platforms For AD&D Professionals, Q1 2019"

I'm not sure how a database applies to sitting around with dice and figurines, but I've never really understood that whole pro gamer thing.

[ Parent | on HN ]