The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
It is poison, don't use it, we have so many application written by a lousy programmer in MS Access that i just can tell you STAHP, don't even think about it. Although for home DB stuff where you like to do things clicky shiny fast you might peek into it
Professionally I use SQL Express, LocalDB and MySQL and couldn't think of any reason to use Access. Just though it was a hang over from another era, and looking at the comments, looks like it is.
So why is it still shipped? MS has dropped other technologies over the years? I guess it still has a large user base
There is no other choice if you need a multi-user database shared over a network, and you can not install SQL Server or any other database server. You cannot achieve this with SQLite or SqlServer Compact Edition.
Unfortunately, it was a LONG time ago when I read that. I think it was around the time Sql Server Express came out.
Google or Bing will reveal many non-Microsoft people who have had trouble with corrupted Access database files when trying to share on a network.
In fact, that was what caused me to first try Sql Server Express. I was brought in to help fix an Access application that was getting corrupt access network files. So I switched the whole Access application to using Sql Server Express instead and they never had another problem.
At that time Sql Server Express was limited to 5 simultaneous usage, but I think they have taken that and other limits off in the more recent versions.
I think that about all I use Access for anymore is the "documenter". I use SQL Server but access has a neat and concise way to print off details of the tables that I haven't found anywhere in the stock SQL Management utility.
Access is part of about 90% of my development projects. Usually as a RAD front end to MySQL, PostgresSQL, Oracle, SQL Server, and sometimes more than one at the same time. How many dev tools do you know that can connect to SQL Server, MySQL and Oracle at the same time?
The ACE DB Engine is really only good for apps with tables less than 100K records, or so, but Access makes a great desktop front-end. Access != ACE (Access <> ACE for the VB fans).
As I've grown as a coder, it took me a while to understand certain concepts that are now must have features in modern languages/ide's: Managed Code, VBA in Access has always been managed. Lambda Expressions, oh, you mean you can just create a function and call it from anywhere? You know, like a function in an Access module rather than class.
Binding fields in a table to controls on a form is ridiculously easy (built-in sanitizing, character limits that match the field, data-types, a plethora of events to add validations, etc.). Don't worry if this frightens you, its lack of layers scares many.
But, then again, you may not want to listen to me as I am a wildling coder. After some excellent instruction in high school, I did not go the the ivory towers and have spent most of my career on the other side of the wall between IT and everyone else... solving problems as quickly and efficiently as I can, with only the tools I have available to me.
"But then, something happened that the ring did not intend." - Fellowship of the Ring
Though I wouldn't want to try to support a commercial multi customer app in Access (did that), it's a very useful companion tool to any development and great, especially due to integration with excel, as a tool in data conversions.
I use .NET, node and other modern tools, and cram until my head aches to try to stay up to date, but I also use Access as a flexible utility, data monitor, checker, builder, relater. i can whip up a form to watch or query certain data that i need to look at on the fly when developing.
plus i have a few customers that still use and like access. if it ain't broke, don't fix it.
Programming a large application in Access is really difficult. But MS lets people get started with Access with no programming knowledge threshold. Access works if you know how to make it work - but people with the skills to do that are programming something else.
´Mr. A at the next desk is cursing it right now. as it seems, some system variables change their names when the users have different language settings, which breaks the application. Great idea to 'help' programming noobs by translating some variable names.
"I don't know, extraterrestrial?"
"You mean like from space?"
"No, from Canada."
If software development were a circus, we would all be the clowns.