3 ms·
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
by Clubber 7y ago
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.
- SigmundA 7y agoI got started using Access 2, so I'm older...
- ourmandave 7y agoLearned 3NF in an Access 2 class, so I might be older... =)
- linuxhiker 7y agoDbase3 and Clipper here.
- pgrote 7y agoI hear you and raise you a Progress.
- tlavoie 7y agoUgh, 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.
- HenryBemis 7y agoI 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!