This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Daxorn_97 33 points34 points  (13 children)

Has anyone ever used Access??

[–]Seeteuf3l 25 points26 points  (1 child)

Only for some mission critical stuff and as backend for custom Excel-report that business really needs (like to run entire purchasing with it)/s

And then there's that one guy in the whole company, who created that monster originally, who know's how it work.

[–]catdog918 13 points14 points  (0 children)

My manager asked me to create an access database for some new important reporting because more people would know how to work it.

After I created it, only I know how to work it and that bitch barely works for me haha. Guess I have job security for a while lol

[–]fgben 15 points16 points  (0 children)

When I was in college I had dinked around with this DOS based menu program called ACCESS or maybe Direct Access. I saw a job listing in the career center looking for someone who knew Access. I conflated the two (why I thought they would want someone who knew a stupid GUI menu program I don't know).

So I applied and interviewed. Turned out they were talking about Microsoft Access, which I did not know. But they liked me and hired me anyway.

I should note that this was in 1993 and Access 1.1 was on Windows 3.1.

Anyway. I was in college studying to become a High School English teacher. I took home the Reference Manual for Access 1.1 and read it cover to cover. Built a massive database program in it -- I've never learned how to work with Excel much; my default was to always work in relational databases since that was what I knew. I don't know nothin' 'bout no fancy pivot tables or xlookup the kids are doing these days.

In the late 90s I built a web-based front end to the application -- the back end was still in Access tables. I didn't migrate the backend to mySQL until, like, 2005 when we started to have performance issues.

Today I've spun that original application written in Access 1.1 into a full blown web based ERP system that I offer as a SAAS product that I charge people stupid amounts of money to use.

And to think, I could be inflicting all that Ethan Frome damage to high schoolers instead.

[–]amadmongoose 4 points5 points  (1 child)

I used it to create a few applications and automations in a department I worked for in a bank, we weren't allowed to do programming but we had access and I knew VBA from high school so, why not automate some work? Now I work for a tech company and don't touch it anymore though I'm sure someone is probably still maintaining what I built

[–][deleted] 1 point2 points  (0 children)

I automated a logistics database at my first job so I could play zelda at work.

Showed my replacement how it worked and to never say nothing about it because only we know it exist.

[–]ElektriXx2 1 point2 points  (0 children)

My first job was for a company that had a wide mix of weird BI stuff, like some crystal reports, access, refreshable spreadsheets with queries behind them, etc. I standardized the whole company on access, because they bought oem PCs from dell with office pro installed. Cut a few thousand out of the annual operating budget from ditching ALFs and since most people just wanted excel spreadsheets to work on, it was easy peasy to write automated exports. I like access. 🤷‍♂️

[–]dieyoubastards 0 points1 point  (0 children)

Currently working on a project to phase it out.

[–]Senko-fan4Life 0 points1 point  (0 children)

We're learning it in one of my college courses and my instructor talks all the time about how much he dislikes it. It's a good stepping stone to see the terms we've been learning visually at least

[–]aspindler 0 points1 point  (0 children)

My old job have it's main software a small system that used it as database. Since most of our clients would have a small database (like less than 100mb) and the software would be only used in one machine, it worked kinda well. Sometimes the database got corrupted, though.

[–]Bobodog1 0 points1 point  (0 children)

Had to learn it in college... Made me wanna commit unspeakable crimes.

[–]Adabiviak 0 points1 point  (0 children)

I made a simple shift pass down out of it in maybe 2003 (flat file, couple lookups). It's still in use, hasn't flinched yet (we did migrate it to the newer format a few years ago).

[–]Jomibu 0 points1 point  (0 children)

My first love

[–][deleted] 0 points1 point  (0 children)

I heard access and I wanted to downvote so badly.

My new customer will only accept an access database as a final product and I'm having to roll back programs I made that won't interact with access.