Is any one using MS Access?

HobbyProggy

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 :)

Rules for the FOSW ![^]

if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}

Lost User

´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.

The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a fucking golf cart.
"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.

den2k88

SPoss wrote:

Does anyone use it?

Yes.

SPoss wrote:

What for?

Gods know.

SPoss wrote:

I've never used it.

SPoss wrote:

and should I?

No, if you're sane and have a good karma. It should be a local DBMS, it is... we never discovered.

GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver "When you have eliminated the JavaScript, whatever remains must be an empty page." -- Mike Hankey

den2k88

There is a Hell sepcifically for the people who thought of it. Not a circle - an entire Hell. Just for them.

GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver "When you have eliminated the JavaScript, whatever remains must be an empty page." -- Mike Hankey

SPoss

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

Mario Z

Yeah, this pretty much sums me up. :laugh:

HobbyProggy

As i said, it is easy to set up stuff, so non programmers and hobby IT people can use it. That's the result of big "fanbase" i'd say. But if you start coding and doing stuff in it you'll get sick...

Rules for the FOSW ![^]

if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}

den2k88

SPoss wrote:

Just though it was a hang over

Given the case, hangover would be more appropriate.

GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver "When you have eliminated the JavaScript, whatever remains must be an empty page." -- Mike Hankey

Johnny J

Not anymore, but up to 15 years ago, it was da shit for database "applications"... Access itself is not used much anymore, but the database file format can still be found in a lot of .NET applications because it's small, single file and doesn't require the presence of an SQL server instance. And "NO", you shouldn't use it. That time has passed! You don't even need to install it! :doh:

Anything that is unrelated to elephants is irrelephant
Anonymous
-----
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-----
I'd just like a chance to prove that money can't make me happy.
Me, all the time

OriginalGriff

Access is a database system - and yes, it's still used. Should you? Probably not. It's not a bad DB system, and for a single user it works fine, the management system isn't bad, and it's easy to work with from your code. But...as soon as you move to a multi user environment, it all turns to poo. Personally, I paid for it as part of Office, but I don't use it - I use SQL Server instead, even for "private" single user (i.e. me) applications. Internally, it uses the same files as Access, but it wraps it in a layer of comforting security.

Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...

SPoss

I've reviewed the comments and have decided NOT to consider Access for anything, I apologise to everyone for bring it up and will seek counselling to prevent me having these though again. :)

SPoss

I remember it been used along time ago for a stores DB (not by me, I was young and DB were the preserve of the gods!!) But if I want a DB for my app I've always used SQL Compact and lately, LocalDB.

Amarnath S

SPoss wrote:

What for?

To upgrade all your legacy .mdb files to the latest version. Not likely, but still no one knows when MS will stop supporting Versions 200x of those.

den2k88

The code I'm working with is 15 years old and we are using an MDB file, compatible only with Access 97. We really don't have the time to change DB format but it's in the TODO... It corrupts. Alone. With a single user. And a fixed set of instructions...

GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver "When you have eliminated the JavaScript, whatever remains must be an empty page." -- Mike Hankey

Johnny J

den2k88 wrote:

It corrupts. Alone. With a single user. And a fixed set of instructions...

Sounds like a disk IO problem... :confused:

Anything that is unrelated to elephants is irrelephant
Anonymous
-----
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-----
I'd just like a chance to prove that money can't make me happy.
Me, all the time

den2k88

The software saves hundreds of images and long textual reports daily for years without fail, only the MDB corrupts - probably it is a problem in deletion of records, as usually only the last 30 days are kept in the DB. The fact is that we do nothing wrong... except using the JET engine, that is wrong by definition.

GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver "When you have eliminated the JavaScript, whatever remains must be an empty page." -- Mike Hankey

chriselst

My dad uses it. He worked for many years as a VAT Inspector before becoming an internal auditor for Customs & Excise. This made him a very boring man. He has a number of Access DBs he has created on his laptop to store his stuff on. It is perfect for that.

Some men are born mediocre, some men achieve mediocrity, and some men have mediocrity thrust upon them.

Wastedtalent

Avijnata wrote:

no one knows when MS will stop supporting Versions 200x of those.

The trouble is, a lot of MS Access isn't even backwards compatible. We have one database in our office that uses it and tbh I can't wait to find time to replace it.

phil o

I use it only for personal-use databases. For a production database, or if the number of expected users exceeds 1, I would rather avoid Access' usage.

while (true) {
continue;
}

GuyThiebaut

Hi, my Name's Guy and I used to be an Access developer. I used to write applications with Access(Years ago) - most of them were coding horrors. I would recommend avoiding it. It presents itself as a quick way top write database based applications without needing to know about good database or good application design. Sure it looks nice to end-users and persuades them that they can code and create databases - however the chimera of monstrosities that have been birthed by Access would make even Cerberus throw up his dinner and I understand that if there was a modern day Sisyphus, his task would be to fix Access databases and Access applications. What starts off as a quick and easy application gets added to and after a few years data a business relies on is embedded in a system that hides functionality and makes tracing issues difficult.

“That which can be asserted without evidence, can be dismissed without evidence.”

― Christopher Hitchens