Go Back   Access World Forums > Non-Access Issues > Debates

 
Reply
 
Thread Tools Rating: Thread Rating: 12 votes, 5.00 average. Display Modes
Old 08-15-2013, 06:12 AM   #1
Jon
Access World Site Owner
 
Jon's Avatar
 
Join Date: Sep 1999
Location: East Sussex, UK
Posts: 789
Thanks: 13
Thanked 1,887 Times in 62 Posts
Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future
Is Microsoft Access a 'proper' database?

Is it good enough or should companies be using something else?

__________________
Regards,

Jon
Jon is offline   Reply With Quote
Old 08-20-2013, 09:37 AM   #2
Vassago
Administrator
 
Join Date: Dec 2002
Location: Jacksonville, FL
Posts: 4,357
Thanks: 82
Thanked 95 Times in 89 Posts
Vassago has a spectacular aura about Vassago has a spectacular aura about Vassago has a spectacular aura about
Re: Is Microsoft Access a 'proper' database?

I believe it's good for small business. For larger companies, it can be problematic. It doesn't have the security that a lot of companies require. My company began phasing it out years ago. We still have some live access databases, but not many. Most have been converted to SQL Server.
__________________
Vassago
Vassago is offline   Reply With Quote
Old 08-21-2013, 10:44 AM   #3
Joe8915
Newly Registered User
 
Joe8915's Avatar
 
Join Date: Sep 2002
Location: Colorado
Posts: 821
Thanks: 66
Thanked 2 Times in 2 Posts
Joe8915 is on a distinguished road
Re: Is Microsoft Access a 'proper' database?

Quote:
Originally Posted by Vassago View Post
I believe it's good for small business. For larger companies, it can be problematic. It doesn't have the security that a lot of companies require. My company began phasing it out years ago. We still have some live access databases, but not many. Most have been converted to SQL Server.
Same here, I built this db 15 years ago and now its converted to SQL. It was a good run, had alot of good help here. Now with only a few months left before I retire, it was fun.

O by the way, they brought in another db to take the place of mine and what a joke. They bought it off the shelf and trying to convert to our needs. I just sit back and watch things tumble.

__________________
Men and Women love their country, not because it is great, but because it is their own.
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
Joe8915 is offline   Reply With Quote
Old 08-21-2013, 01:04 AM   #4
ButtonMoon
Newly Registered User
 
Join Date: Jun 2012
Posts: 304
Thanks: 11
Thanked 56 Times in 55 Posts
ButtonMoon will become famous soon enough
Re: Is Microsoft Access a 'proper' database?

Access self-evidently is not a "database". It is an application development tool. As an application development tool it's never going to compete with more mainstream RAD tools based on .net or Java, say, but Access fits its own niche quite nicely. The main drawbacks for most people are that it lacks many important features found elsewhere. It isn't as secure, scalable or robust as other alternatives and doesn't offer the same integration possibililities or have good support for modern n-tier, web-based and services-based architectures. This rules it out for many enterprise applications but suits desktop, small departmental or SME applications.
ButtonMoon is offline   Reply With Quote
Old 09-07-2013, 01:59 AM   #5
fortion
Newly Registered User
 
Join Date: Sep 2013
Posts: 40
Thanks: 0
Thanked 3 Times in 3 Posts
fortion is on a distinguished road
Re: Is Microsoft Access a 'proper' database?

improve the security of the database and access can cater to all companies.
fortion is offline   Reply With Quote
Old 09-07-2013, 02:31 AM   #6
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,327
Thanks: 40
Thanked 3,667 Times in 3,536 Posts
CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light CJ_London is a glorious beacon of light
Re: Is Microsoft Access a 'proper' database?

I'm with Button.

Define 'proper'! Access is a flexible tool which bridges the gap between Excel and mainstream systems using database structures and has the benefit of being a front end development tool as well.

I agree security can be an issue but I still see many large corporations using it as a necessary tool - even if not supported by IT.

Scaleability can be an issue however relatively easily overcome by having multiple back ends - but it is never going to provide the basis of say a billing system for a company generating millions of invoices a month.

In this world of rapid change, 'strategic' solutions or 'proper' databases are often too slow to change so companies can lose strategic advantage. I make my living providing 'tactical' solutions, designed to last perhaps a couple of years until the strategic solutions can catch up.

I tend to get involved in three areas:
1. Company A takes over company B, both have their own strategic solutions but they need to be merged now, not in 2 years time - think territory management, sales commissions, purchasing alliance
2. Company is in a rapidly converging market where new products are added and company faces different competition - think telecoms which has expanded to include landline, mobile, SMS, 3g, 4g, content
3. Company has developed key processes in Excel and now can't cope. Lots of those! - and why were they developed in Excel the first place? Because they either weren't in a position to define a strategic requirement or the required solution would take too long.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is online now   Reply With Quote
Old 09-07-2013, 02:45 AM   #7
nanscombe
Newly Registered User
 
nanscombe's Avatar
 
Join Date: Nov 2011
Location: Kent, UK.
Posts: 1,082
Thanks: 0
Thanked 256 Times in 249 Posts
nanscombe will become famous soon enough
Re: Is Microsoft Access a 'proper' database?

I used to produce Access solutions for a dispersed business which had small pockets of geographically independent users, 20 or so offices each with around a dozen users.

If all of the offices produce / consume their own data you can, as long as the database is designed well, consolidate the data every now and then to get an overall picture of what's going on.

If all the users need to be able to see all of the data all of the time it would certainly be a challenge. However, before I was made redundant, I did produce a few databases which were gradually being migrated onto a Citrix farm to be used from a central location.

__________________
Nigel
Ex Tactical Systems developer
nanscombe is offline   Reply With Quote
Old 09-17-2013, 08:07 PM   #8
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,522
Thanks: 92
Thanked 1,674 Times in 1,554 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Is Microsoft Access a 'proper' database?

I'm still working on a sentence that uses "Microsoft" and "proper" in the same breath. Even if 'proper' was in quotes.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 09-17-2013, 08:32 PM   #9
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,380
Thanks: 21
Thanked 896 Times in 881 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: Is Microsoft Access a 'proper' database?

Hmm, this is tough to answer without a clear definition of 'proper".

Should companies be using something else? I have designed databases for small companies (1 to 20) to large corporations (20 to 200+) utilizing SQL Server when security was an issue. (I never bothered with the security in Access as 90% of the time it could be cracked.)

IMHO, there is no other RAD Tool available that allows one to produce something that the company can have *their way*. No other Tool that allows customization *on-the-fly* and now. For several of my Clients they looked around but nothing did what they wanted and the way they wanted... Access allows that. So, to answer your question, show me the *something else* that you *think* they should be using but in my opinion, no... there is nothing else... at least not yet.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 09-18-2013, 12:24 AM   #10
RainLover
VIP From a land downunder
 
RainLover's Avatar
 
Join Date: Jan 2009
Location: Qld Australia
Posts: 5,044
Thanks: 28
Thanked 517 Times in 492 Posts
RainLover will become famous soon enough
Re: Is Microsoft Access a 'proper' database?

If you think about it, database management systems have even existed for thousands of years. However, in the earlier days they were recorded without computers, rather than with crude accounting systems that companies like banks used to use over hundreds of years ago.

Access must therefore be considered to be a Database simply because it stores and retrieves data. To expand on this one might say that Microsoft Outlook is the biggest database of all as world wide it handles more data than any other single database.

The next question should be isolated from the first. Is Access good enough to be used by companies.

In fact Companies do not use databases people do. It is people of all stations within the company that may have the need for a database. It can be these same people that write their own database.

No one could possibly consider something like SAP for use by the receptionist to track visitors. Nor would one recommend Access to track the assets of a multi billion dollar company.

There is no one database that will suit all your needs. Simply use the one that best suits your needs and abilities.
__________________
Regards Rain.

Windows 7. Access 2003. East Coast Australia. GMT +10,

RainLover is offline   Reply With Quote
Old 10-25-2013, 02:36 PM   #11
MLUCKHAM
Newly Registered User
 
Join Date: Jul 2013
Posts: 89
Thanks: 3
Thanked 8 Times in 8 Posts
MLUCKHAM is on a distinguished road
Re: Is Microsoft Access a 'proper' database?

Short answer, No. SQL Server is a proper database. But... combine the two and you have a powerful toolkit! There is nothing like Access for serious rad development!
MLUCKHAM is offline   Reply With Quote
Old 10-25-2013, 02:43 PM   #12
Royce
Access Developer
 
Join Date: Nov 2012
Posts: 95
Thanks: 8
Thanked 9 Times in 9 Posts
Royce is on a distinguished road
Re: Is Microsoft Access a 'proper' database?

This link gives the best overview of the pros and cons of Access that I've seen.
http://www.fmsinc.com/MicrosoftAcces...tegy/index.asp

Access is quick and inexpensive for smaller projects, shouldn't be used for larger ones. My experience has been that problems increase significantly as the number of concurrent users increases. I've seen 20 users work fine. But I've also seen 5 or 6 heavy users have problems. SQL on the backend solves a lot of problems.
Royce is offline   Reply With Quote
Old 10-20-2014, 04:07 AM   #13
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,791
Thanks: 55
Thanked 1,027 Times in 993 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
Re: Is Microsoft Access a 'proper' database?

late joiner to this one.

if companies can use Excel without a thought about "security" and so on, (which they do) then of course they can use Access. At the very least, Access brings robustness and speed to excel databases.

The biggest problem is not the security, imo, it's that Access is not trivial to use in the way that excel is. You can use excel without ever writing a macro, and certainly never writing code. you just cannot get anywhere in access without code. you also have to understand normalisation, and RI in a way that has no application to excel.
__________________
Dave (Male!)
Gemma was my dog

if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.
gemma-the-husky is offline   Reply With Quote
Old 10-20-2014, 04:28 PM   #14
RainLover
VIP From a land downunder
 
RainLover's Avatar
 
Join Date: Jan 2009
Location: Qld Australia
Posts: 5,044
Thanks: 28
Thanked 517 Times in 492 Posts
RainLover will become famous soon enough
Re: Is Microsoft Access a 'proper' database?

To follow on Dave's thoughts.

Although we do use excel without Higher Level Security I believe we should do things where we can that will limit the hacker's ability. True you will never keep an honest person out we can limit their temptation.

Two simple things is to disable the shift key on start up and to convert to a mde file. Making sure you have several backups.
__________________
Regards Rain.

Windows 7. Access 2003. East Coast Australia. GMT +10,


Last edited by RainLover; 10-20-2014 at 04:56 PM.
RainLover is offline   Reply With Quote
Old 10-20-2014, 11:21 PM   #15
Brianwarnock
Retired
 
Brianwarnock's Avatar
 
Join Date: Jun 2003
Location: Merseyside England
Posts: 12,701
Thanks: 39
Thanked 539 Times in 521 Posts
Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light Brianwarnock is a glorious beacon of light
Re: Is Microsoft Access a 'proper' database?

Quote:
Originally Posted by RainLover View Post
?..... you will never keep an honest person out we can limit their temptation.

s.
To pick up on this , when , a life time ago, I was responsible for the implementation of security on our main frames (RACF for those who want to know), our mantra was that you cannot blame a guy for doing what he can, we have to ensure that he can only do what he should.

Brian
__________________
What is this life if, full of care,
We have no time to stand and stare

I do not have Access these days 2015
Brianwarnock is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Forgot Microsoft Access Database Password Rajkishore Rout General 23 02-10-2015 02:47 PM
Question Microsoft Access Database Help ChrisKipper General 5 01-18-2013 03:07 PM
Question Microsoft Works Database v. Microsoft Access akt01 General 10 02-02-2009 03:01 PM
microsoft access database error message chedwo Tables 4 01-16-2008 10:40 AM
Microsoft Access was unable to create an MDE database Tsango General 2 04-02-2006 09:36 AM




All times are GMT -8. The time now is 03:12 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World