Access - Devastation (1 Viewer)

[KitaYama]

The number of Linux distros, creates a vibrancy, it does not affect how the vast majority of applications, such as LibreOffice work.

You missed the point.
Linux was just an example on how the variants may spread. Linux is an OS and an application may be written somehow to run on all distributions.
Access is an application and if there's any variant of an application, there's a good chance other distributions can not open or work on it.

 

[KitaYama]

The many distros of Linux makes the product more popular and versatile, I don't believe it weakens it. But it is a interesting argument.

@AccessBlaster Are we talking about popularity or about a standard? Access is much popular just now and needs no more popularity. I don't think I need to explain for an application how serious it is to have a standard. Just imagine what a mess would it be if variantA of Access has different rules for the structure of a table or a form than variantB.
And now go further and imagine the count of Access distros goes up to the list I gave you. If you don't call it a disaster, what do you call it at all?

If there's any distros of an app, they may have different ways of doing things and to me it's a disaster. though it may be popularity for you.

 

[Ari]

Forget all that because young people have already taken another direction. MS Access is being supported by a generation over the age of 50. The MS Access curve is following the curve of the elderly. So it doesn't matter here whether MS Access is good or bad.

 

[GPGeorge]

Ah to have the arrogance and innocence of youth again.

 

[NauticalGent]

Ah to have the arrogance and innocence of youth again.

 

[NauticalGent]

Also, you misspelled "ignorance", but I do not want to be the grammar/spelling Nazi this early on a Monday.

 

[GPGeorge]

Also, you misspelled "ignorance", but I do not want to be the grammar/spelling Nazi this early on a Monday.

We could quibble about motivation, I suppose.

 

[AccessBlaster]

Forget all that because young people have already taken another direction. MS Access is being supported by a generation over the age of 50. The MS Access curve is following the curve of the elderly. So it doesn't matter here whether MS Access is good or bad.

The best observation regarding MS Access so far, thank you!

 

[Steve R.]

Forget all that because young people have already taken another direction. MS Access is being supported by a generation over the age of 50. The MS Access curve is following the curve of the elderly. So it doesn't matter here whether MS Access is good or bad.

A bit more complicated. Several other, not necessarily obvious reasons:

• Microsoft has "abandoned" MS Access. Ironically, the Linux version of a DMS (base) has also been "abandoned". The word "abandoned" could be considered a bit too strong.
• When I was working with MS Access, the MIS staff where I worked undermined attempts to use MS Access. An implication here, is that MS Access remains suitable were the user is the MIS department. Small business being one area were MS Access could still excel.
• Technology has evolved. I have found Linux and MariaDB to be a "superior" approach to database management. I guess, being retired and over 50, I am really a trend setter (follower?) in moving-on as technology has evolved.

 

[AccessBlaster]

Just kidding!

 

[AccessBlaster]

as long as you don't need a web presence,

And there's the rub...

 

[Cotswold]

My opinion is that Access doesn't appear to have any competition for a desktop development.

Whenever you are looking at the Ten Best Alternatives to Access, all of them include Libra or OpenOffice, which simply displays that these self-appointed advisors (advertisers?) do not know what they are talking about. You have to conclude that they have never developed anything useful for others to use in their life.

Access is often slated but it has been (for me) a reliable development language for business systems for nearly 30 years, frequently upgrading. I have used Access since Access97 and have always been able to create even the most complex screens and reports using easily developed queries. I don't believe that commerce or industry can be, or ever will be able to operate on a smartphone. But it does appear that there are some who do not understand business applications and are ambitious that the smartphone will eventually do everything. A bit like those who think that providing a CHAT feature on their website is an excellent way of providing remote help or assistance.

Microsoft clearly want only totally web based developments, which Access will never be. But it does have a place in the scheme of things. They should accept this and maintain the product professionally instead of treating it as lower-class or some sort of nuisance in the whole Microsoft scheme of things. It has served them well for over 30 years and can continue to do so.

Hopefully Microsoft will continue to develop Access and add new features. Also, stop treating it like a hospital job, or something to give an apprentice to do when they are a little short of work for them.

To reiterate; if you looked at the ten best alternatives to Access, by the time you've got to number ten, you realise there isn't a single alternative that you can switch to.....well I haven't found one anyway

 

[Steve R.]

To reiterate; if you looked at the ten best alternatives to Access, by the time you've got to number ten, you realise there isn't a single alternative that you can switch to.....well I haven't found one anyway

Well, one can assemble an Access equivalent by installing a variety of applications. This requires, a database, browser, apache, php, html, CSS, javascript, etc. Takes a bit of work to integrate these applications, but the results are well worth it. One item of good news, this alternative approach to MS Access is $$$ free. If I can do it, anyone can.

 

[GPGeorge]

Well, one can assemble an Access equivalent by installing a variety of applications.

Spoiler: etc

This requires, a database, browser, apache, php, html, CSS, javascript, etc. Takes a bit of work to integrate these applications, but the results are well worth it. One item of good news, this alternative approach to MS Access is $$$ free. If I can do it, anyone can.

 

[Ari]

Here's a quick survey of subscribers on my website from 2017 to 2022.

Total subscribers in the period: 2274

10 to 24 years: 60
25 to 30 years: 180
31 to 40 years: 574
41 to 50 years: 703
51 to 99 years: 757

5 years and only 60 subscribers, under 25 years.

Have you noticed that most of the participants of this topic are over 50 years old?

 

[CJ_London]

just means they haven't discovered the benefits of Access

 

[KitaYama]

This requires, a database, browser, apache, php, html, CSS, javascript, etc. Takes a bit of work to integrate these applications, but the results are well worth it. One item of good news, this alternative approach to MS Access is $$$ free.

@Steve R. I can't believe you're comparing PHP with MySQL on an apachee with Access.
Just let me ask you a question.

With above circumstances, Can you bound a form on a web page to a recordset or a table or a query?

 

[isladogs]

Here's a quick survey of subscribers on my website from 2017 to 2022.

Total subscribers in the period: 2274

10 to 24 years: 60
25 to 30 years: 180
31 to 40 years: 574
41 to 50 years: 703
51 to 99 years: 757

5 years and only 60 subscribers, under 25 years.

Have you noticed that most of the participants of this topic are over 50 years old?

Pity you didn't split the over 50s by age decade also. I wonder how many are 90+.

 

[Steve R.]

@Steve R. I can't believe you're comparing PHP with MySQL on an apachee with Access.
Just let me ask you a question.

With above circumstances, Can you bound a form on a web page to a recordset or a table or a query?

H'mmm. In a sense this is a case of apples and oranges.

• Apache is is the server that allows the database to be accessed by any computer on the local LAN.
• In my case, I use MariaDB (a MySQL fork). That is where the data is actually stored.
• PHP is used to interrogate the database (on the server). I suppose you can say that PHP creates a faux rerecord set through issuing an SQL statement. PHP reads and writes to the database. It also allows scrolling.
• The form, which is viewed through a browser, is visually created through HTML, and CSS.

 

[Ari]

@Ari If you don't like Access or don't think it is a worthwhile tool, perhaps you should move on People who think they are working with inferior tools are always unhappy.

Pat Hartman, I think you're misjudging me. We know very well the potential of Ms Access, and there is no dispute about it. What I am bringing here are numbers, which show a trend towards the distance of young people. I posted a link to a forum on electronics, wanting to show the degree of dissatisfaction people have with Microsoft.

Looking on the optimistic side, the trend shows that there will be a shortage of VBA programmers and this could bring better job opportunities and appreciation.