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

 
Reply
 
Thread Tools Rating: Thread Rating: 12 votes, 5.00 average. Display Modes
Old 07-25-2015, 11:14 AM   #61
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?

All

I have just done some editing to my posts.

I am not feeling 100% at the moment so I think I wrote some things that upon reflection did not fit in with the topic.

Please accept my apologies.

__________________
Regards Rain.

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

RainLover is offline   Reply With Quote
Old 07-25-2015, 02:02 PM   #62
speakers_86
I am jack's comment.
 
speakers_86's Avatar
 
Join Date: May 2007
Location: JBLM, Wa
Posts: 1,919
Thanks: 11
Thanked 160 Times in 119 Posts
speakers_86 will become famous soon enough
Re: Is Microsoft Access a 'proper' database?

Is it proper? Define proper.

It is great for some things. I would say it is great for small businesses, for rapid solutions, and to teach people how to code. Outside of this, other solutions are probably better.
__________________
If you look, you can find anything.
Google is your friend.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


~~~~~~~~~~~~~~~~~~~~~~~~~~~
Access 2010 screw this! I went back to 2007
Windows 7
speakers_86 is offline   Reply With Quote
Old 08-02-2015, 11:02 PM   #63
Lightwave
Ad astra
 
Lightwave's Avatar
 
Join Date: Sep 2004
Location: Edinburgh
Posts: 1,401
Thanks: 123
Thanked 137 Times in 129 Posts
Lightwave will become famous soon enough
Re: Is Microsoft Access a 'proper' database?

Apologies Rain I was meaning have you tried Access 2003 in Windows 2010.

I am presuming it will work

Lightwave is offline   Reply With Quote
Old 08-03-2015, 02:29 AM   #64
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?

Quote:
Originally Posted by Lightwave View Post
Apologies Rain I was meaning have you tried Access 2003 in Windows 2010.

I am presuming it will work
No I haven't. I am semi retired so what I can't do in 2003 or 2007 does not have any real interest to me.
__________________
Regards Rain.

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

RainLover is offline   Reply With Quote
Old 08-11-2015, 06:03 AM   #65
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,367
Thanks: 87
Thanked 1,644 Times in 1,526 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 going to toss another stink-bomb into this conversation because in reviewing, I saw a statement that just ain't so. The comment was made that you might not want to use Access to host a database because of speed considerations. Speed vs. what?

Most systems I know do not compile SQL, they just semi-compile it into some emulation code that looks like, but is not, machine code - because there is no physical machine behind it with that instruction set and also because the "instructions" of this putative machine are not primitives - they are complex macro-instructions - like SELECT or INSERT INTO or UPDATE or DELETE that affect whole groups of data at one time. No, SQL is at most interpreted (not compiled) on even the ORACLE systems. So that leaves us with the question of "which brand-name DBMS interprets text faster?" That depends more on the amount of overhead in each interpreter than on the language being interpreted.

Both Access and ORACLE use tables with indexes for faster lookup. ORACLE's advantage isn't speed, here - it is SIZE. The indexes that "point" to data can be more than 2 Gb of equivalent address space. But the bigger address space actually SLOWS DOWN the way the "big boy" jumps around - because it has to manipulate that longer address a bit more - and in a way that depends on the O/S. The speed of searching, selecting, and JOIN operations depends on the efficiency of the search, selection, and JOIN code routines behind the scenes. ORACLE might do more (in the way of triggers and such), but if you want to compare apples to apples, you turn off the extra stuff before you run comparision operations. Odds are, Access will be able to keep up.

Both Access and the "big boys" use ANSI SQL so they interpret the same features. Whether you name something as a VIEW or a SELECT QUERY, it has the same purpose and still needs to be interpreted. The "interpretation" depends on the efficiency of the pseudo-code emulator. (More about that kind of speed in a moment.)

When you design forms or reports, you make lists of items that are visited by an image driver to draw text boxes, labels, combo boxes, toggle buttons, etc. This is common to both systems. When you use Access FE/BE or when you use VB FE/something else BE, you interpret each page / pane / screen of data - because you DON'T hard-code every control. You build a data structure, define the properties, and call subroutines with subject data structures as the actual arguments, and the subroutines (which ARE compiled) examine the object properties in order to display it. You don't use VB to directly draw any control. The "collection enumeration" algorithms in Access do the same thing - visit the collection of controls and dispatch to the correct drawing routine based on the control-type field. This sounds like I am belaboring the obvious - but I am wading through the weeds to make the point that the various methods every system uses all match up one for one at this level of detail. It is all more or less the same thing being done by different vendors' code. Where is the speed difference?

The "speed difference" between Access and the "big boys" is a chimera - a non-existent creature. Think about it: When you think about fast databases, you do you think about Access hosted on someone's PC? but do you at the same time think about "the big boys" on a multi-processor high-end dedicated server? The speed difference is in the platform and the O/S settings, not in the databases. I've seen the "big boys" run on small PCs and they are no faster than Access would be on the small PCs. When you take away the ability of the BE to use parallel processing, you see the REAL comparison and there is where you find the real speed differential, which is miniscule.

In closing, remember that whether you write in FORTRAN, BASIC, PASCAL, COBOL, P/L-1, or some glorified assembler, it takes the about the same number of compiled instructions to move data from point A to point B regardless of your environment. So when you want to tout the speed of your database system, remember that it is the platform, not the software, that gives you the appearance of speed.

Having said that, I acknowledge that if you ran Access on the hottest PC you could find, it would still be single-threaded because it was not written to use multiple CPUs or cores (unless it now does that and I just missed the advent of that option.)

I think I've become a sadistic sodomistic necrophile, because I'm pretty sure I've beaten this horse to death. (Apologies to Woody Allen and What's up Tiger Lily?) But I just couldn't let the "speed" chimera out there without challenging it.
__________________
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 02-10-2018, 06:50 PM   #66
mrsiro
Newly Registered User
 
Join Date: Feb 2018
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
mrsiro is on a distinguished road
Re: Is Microsoft Access a 'proper' database?

A bussiness small, it's proper. Another, it's not.
mrsiro is offline   Reply With Quote
Old 01-29-2019, 11:09 AM   #67
gema57
Newly Registered User
 
Join Date: Jan 2019
Posts: 17
Thanks: 28
Thanked 0 Times in 0 Posts
gema57 is on a distinguished road
Re: Is Microsoft Access a 'proper' database?

Quote:
Originally Posted by Jon View Post
Is it good enough or should companies be using something else?
It is a very good database for a small businesses, after when your database grows nothing deters to you to migrate toward SQL Server, or MySQL. I love very much Microsoft Access, as I learnt Database, how to build it with Microsoft Access 97. Moreover, it has useful tools and you could use Microsoft Excel.

gema57 is offline   Reply With Quote
Old 08-27-2019, 02:42 AM   #68
amo12oo
Newly Registered User
 
Join Date: Aug 2019
Posts: 10
Thanks: 1
Thanked 0 Times in 0 Posts
amo12oo is on a distinguished road
Re: Is Microsoft Access a 'proper' database?

maybe for personal use or small business/office.
amo12oo is offline   Reply With Quote
Old 08-27-2019, 03:35 AM   #69
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,241
Thanks: 40
Thanked 3,646 Times in 3,516 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?

Haven't reread the whole thread but access is two things - a back end database and a front end development environment. The front end does not need to use the access backend, it can use pretty much any rdbms.

with regards only suitable for small companies I completely disagree. With a couple of exceptions all my clients are national or multi national and typically the apps developed fill the gaps the corporate systems can't, usually because of budget or resource constraints.

That is not to say there aren't other options out there that could be used. But one of the benefits of using access is development time. Because many of the controls are preformed they only need the minimum of configuration.

One of the potential disadvantages of access is the app is client based (the program resides on the client machine) rather than host based (the program resides on the server). So maintenance of the FE becomes a bit more problematic if you have 600 user machines to update with a revised FE - note 600 assumes the BE is sql server or similar.

Another is the FE really needs to be hardwired to the BE rather than using wireless. But there are ways round that. In some respects it can be seen as an advantage because the requirement for hardwire simplifies potential security issues.
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
Old 08-27-2019, 05:33 AM   #70
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,367
Thanks: 87
Thanked 1,644 Times in 1,526 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?

amo12oo - My personally biggest db was for the U.S.Navy (from which I retired as a contractor after 28 1/2 years). About 30-40 users, data set was basically to record all security-related actions for over 1500 servers crossing 80 projects. Security actions were distributed by the government every 2 weeks and might lead to 30 actions per month, multiply that by 1500 servers and we were tracking 45,000 actions per month, or half a million actions per year. Those 80 projects were essentially Navy, Navy Reserve, and a couple of other government agencies that we managed from a data center. While that isn't the biggest db you might have ever seen, if you are worried about the size of the organization, it was the U.S. Navy. Not small potatoes.

But that wasn't the biggest Access db at the site. Another person managed the one in which they had an Access FE and an SQL Server BE for a Navy medical-records system that potentially covered the entire U.S. Navy through Access as the front-end driver. Don't downplay Access as a "small systems" tool for small shops.
__________________
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 08-27-2019, 05:49 AM   #71
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?

Quote:
Originally Posted by The_Doc_Man View Post
an Access FE and an SQL Server BE
So that would be a SQL Server database, not an Access database. The question here is apparently about Access databases and not about applications developed in Access.
ButtonMoon is offline   Reply With Quote
Old 08-27-2019, 05:59 AM   #72
isladogs
Part time moderator
 
isladogs's Avatar
 
Join Date: Jan 2017
Location: Somerset, UK
Posts: 10,388
Thanks: 112
Thanked 2,849 Times in 2,597 Posts
isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold isladogs is a splendid one to behold
Re: Is Microsoft Access a 'proper' database?

Agree with the comments by CJL and the DocMan.
I have several databases which have run in a number of large secondary schools for many years. Typically there may be 200 users per school and at peak times there can be over 100 of those running an app simultaneously without issues e.g. doing attendance registers where all classes are done at the same times
To manage large numbers of users, the backend data is in SQL Server. This ensures a stable and secure environment without slowdowns or crashes. After 10+ years, one school will in the next year or so need to make a decision about upgrading as they are getting fairly close to the 10GB limit for the free Express version.

EDIT
I also have many other databases with a Access BE. If the number of simultaneous users is no more than 20 or so, this is perfectly good solution. More than that will cause slowdowns and occasional crashes which no longer happen using SQL Server for the BE.
__________________
If this answer has helped, please click the Thanks button and/or click the 'reputation scales' symbol on the left.

Website links:
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


Colin
Access 2010 32-bit, Access 2016 32-bit & 64-bit, SQL Server Express 2014, Windows 10,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
,
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
isladogs is offline   Reply With Quote
Old 08-27-2019, 09:18 AM   #73
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,938
Thanks: 433
Thanked 284 Times in 249 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: Is Microsoft Access a 'proper' database?

Amo12oo has spent some time answering old threads with insignificant, one sentence answers. I’m an only guess at the reason. Time will tell...
__________________
- Ciao, John
NauticalGent is offline   Reply With Quote
Old 08-27-2019, 10:36 AM   #74
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 11,241
Thanks: 40
Thanked 3,646 Times in 3,516 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?

we know - he/she has been warned
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is offline   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
NauticalGent (08-27-2019)
Old 09-03-2019, 05:59 AM   #75
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,367
Thanks: 87
Thanked 1,644 Times in 1,526 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?

ButtonMoon, my take is that if Access is the FE, then the GUI is good enough for big boys in the database industry. And that much of it IS proper. But it is true that we used SQL server because of the security issues as well as capacity issues.

Then again, since Access was intended for small audiences, there is nothing wrong with having to up-convert it once you got the design right. And the fact that you COULD convert it means that it wasn't flawed. Just limited.

__________________
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
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 07:21 AM.


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