Is any one using MS Access?
-
Just updated office 365 and along with it Access 2016. I've never used it. Does anyone use it? What for? and should I?
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 -
Just updated office 365 and along with it Access 2016. I've never used it. Does anyone use it? What for? and should I?
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 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
-
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...
-
Just updated office 365 and along with it Access 2016. I've never used it. Does anyone use it? What for? and should I?
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.
-
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 timeThe 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
-
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
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 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 timeThe 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
-
Just updated office 365 and along with it Access 2016. I've never used it. Does anyone use it? What for? and should I?
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.
-
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.
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.
-
Just updated office 365 and along with it Access 2016. I've never used it. Does anyone use it? What for? and should I?
-
Just updated office 365 and along with it Access 2016. I've never used it. Does anyone use it? What for? and should I?
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
-
Just updated office 365 and along with it Access 2016. I've never used it. Does anyone use it? What for? and should I?
The problem with Access isn't as much Access itself, but rather its intended audience.
Wrong is evil and must be defeated. - Jeff Ello
-
Just updated office 365 and along with it Access 2016. I've never used it. Does anyone use it? What for? and should I?
Does anyone use it? Yes. Are there valid reasons to use it? Yes, with caveats. I have heard of it being used by individuals working for charitable organizations when the individual is essentially cut off from field support, ie: they are on their own. Think interval Africa.. really, used by people in Africa without access to the internet for support. I have seen it used (badly) in a commercial organization by the accounting group because 'someone' thought they knew how to create a database and the attendant code and couldn't be bothered asking the IT department for help.. that would take to long. So, when the database grew to over 5G and couldn't be shrunk and was tied to a particular machine that couldn't be re-imaged, etc... they refused to admit they had erred years before, but reluctantly asked the IT department for help is moving the functionality to SQL Server.
-
Does anyone use it? Yes. Are there valid reasons to use it? Yes, with caveats. I have heard of it being used by individuals working for charitable organizations when the individual is essentially cut off from field support, ie: they are on their own. Think interval Africa.. really, used by people in Africa without access to the internet for support. I have seen it used (badly) in a commercial organization by the accounting group because 'someone' thought they knew how to create a database and the attendant code and couldn't be bothered asking the IT department for help.. that would take to long. So, when the database grew to over 5G and couldn't be shrunk and was tied to a particular machine that couldn't be re-imaged, etc... they refused to admit they had erred years before, but reluctantly asked the IT department for help is moving the functionality to SQL Server.
I was going to say, why don't they use locaDB/sqlexpress instead, but thinking about it, if your in Africa etc, and you're an end user (not a developer), and you have need for a DB, what options do you have? I had a very quick look at access this morning, it does seem to come with ready made templates that an end user could quickly get setup and use. I'm not about to start using it!! :) But for non developer/end users that want a simple DB, what other options do they have? Search for an app already made for the job. As an example, I've just googled 'CD Database software' ... and there where lots of hits
-
Just updated office 365 and along with it Access 2016. I've never used it. Does anyone use it? What for? and should I?
I have a difficult time imagining that a developer has no idea what Access is. Perhaps I missed the sarcasm? Since you already have it installed, I'd suggest that you try it and decide for yourself if it might be useful to you...it won't cost you a thing. That said, I use Access 2003 almost every day. Why? Two words: Query Designer :)
"Go forth into the source" - Neal Morse
-
I have a difficult time imagining that a developer has no idea what Access is. Perhaps I missed the sarcasm? Since you already have it installed, I'd suggest that you try it and decide for yourself if it might be useful to you...it won't cost you a thing. That said, I use Access 2003 almost every day. Why? Two words: Query Designer :)
"Go forth into the source" - Neal Morse
No Sarcasm, genuine question. I've been aware of Access since windows 3.1 (I think access was available then, anyway along time), just never used it. Just never though/considered it's use, no reason not to. During my early programming life, it was all embedded microcontrollers running C/asm with about 32K of program code. My most of the work is still embedded stuff. I've only really started using DB in the last 6 years. combination of sql compact, express, localDb and MySQL, selecting whichever suited the project/client the best. I'm no DB expert, there's always something to learn!! But I updated office yesterday, noticed access and opened it up to have a look. Which made me wonder if any one currently uses it.
-
No Sarcasm, genuine question. I've been aware of Access since windows 3.1 (I think access was available then, anyway along time), just never used it. Just never though/considered it's use, no reason not to. During my early programming life, it was all embedded microcontrollers running C/asm with about 32K of program code. My most of the work is still embedded stuff. I've only really started using DB in the last 6 years. combination of sql compact, express, localDb and MySQL, selecting whichever suited the project/client the best. I'm no DB expert, there's always something to learn!! But I updated office yesterday, noticed access and opened it up to have a look. Which made me wonder if any one currently uses it.
Thank you for reminding me that there is development outside of CRUD which has been my entire career. :) Now, a fair answer to the question about it being used. There are multiple ways Access can be used: 0: Data store for single-user desktop applications (nice because it doesn't even require Access to be present on clients) 1: Developer tool for designing queries used in Access or other sql based rdbm systems 2: Packaged application using VBA and the built-in forms and reports. X| I still see Access as a viable solution for the first 2 use cases. I think the last use case is the one most responsible for Access's bad reputation among developers. I've looked into SQL Compact as a replacement, but can't live without views. :( Anyway, have a great weekend!
"Go forth into the source" - Neal Morse
-
Just updated office 365 and along with it Access 2016. I've never used it. Does anyone use it? What for? and should I?
ACCESS is so good that MS is killing it because is a big competitor of VS. ACCESS is the fastest RAD tool and you can do petty good desktop and web applications for SME or departments almost without code. Access it is simply fantastic. And of course there are millions of people using ACCESS.
-
Just updated office 365 and along with it Access 2016. I've never used it. Does anyone use it? What for? and should I?
I also used MSAccess for back-end DB while ago.. But now I'm using LocalDB or sometimes SQLite... :-D
Don't watch the clock; Do what it does. Keep going.....
